if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  

---

I want to execute a piece of code before calling a procedure. How to achieve it?

1 Answers   Oracle,

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

---

how can you create an empty table from an existing table? : Sql dba

0 Answers  

---

Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?

2 Answers  

---

Types of joins ?

11 Answers   Polaris, TCS,

---

What are the types of records?

0 Answers  

---

Fetch an entire row from the employees table for a specific employee ID:

2 Answers  

---

What does “select count(1) from tab” result?

10 Answers   IBM,

---

What is structural independence and why is it important?

0 Answers  

---

How many functions are there in sql?

0 Answers  

---