one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

What will you get by the cursor attribute sql%notfound?

0 Answers  

---

write a query find which rows of a table is updated on 2 days before?

3 Answers   TCS,

---

<<labele>> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?

1 Answers   ITC Infotech,

---

Does truncate require commit?

0 Answers  

---

---

What is the difference between join and natural join?

0 Answers  

---

What type of join is sql join?

0 Answers  

---

What is the cause of mutating table error and how can we solve it?

0 Answers  

---

Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

1 Answers   TCS,

---

Can we write create command in the plsql block?if possible how?

2 Answers  

---

What is a function in oracle pl sql?

0 Answers  

---

what is a foreign key ? : Sql dba

0 Answers  

---