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,

---

How to create your own reports in sql developer?

0 Answers  

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

0 Answers  

---

What are pl/sql cursors?

0 Answers  

---

How do you create a unique index?

0 Answers  

---

How run sql*plus commands that are stored in a local file?

0 Answers  

---

What is consistency?

0 Answers  

---

What is sorting in sql?

0 Answers  

---

Can you have more than one trigger on a table?

0 Answers  

---

I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  

---

1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,

---

What is the difference between SQL table and the PLSQL table?

3 Answers   Mastek,

---