How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

---

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,

---

what command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,

---

What is function and procedure?

0 Answers  

---

Can I join the same table twice?

0 Answers  

---

---

difference between anonymous blocks and sub-programs.

0 Answers  

---

What is sql*plus?

0 Answers  

---

What is procedure explain with program?

0 Answers  

---

what is primary key? : Sql dba

0 Answers  

---

What is index example?

0 Answers  

---

What is a database? Explain

0 Answers  

---

Can delete statement be rollbacked?

0 Answers  

---