Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

---

How to find only %th Highest Sal

6 Answers   Infogain, Symphony,

---

What is procedure and function?

0 Answers  

---

how to include comments in sql statements? : Sql dba

0 Answers  

---

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,

---

What is where clause in sql?

0 Answers  

---

Are stored procedures faster than dynamic sql?

0 Answers  

---

What is trigger point?

0 Answers  

---

Where the integrity constrints are stored in Data Dictionary?

1 Answers  

---

What is your daily office routine?

0 Answers   Data Vision,

---

use of IN/ANY/ALL

5 Answers   Ramco,

---

Explain table and field in sql?

0 Answers  

---