Answer Posted / pravin jadhav

delete from table_name where rowid not in (select max(rowid) from table group by
duplicate_values_field_name);
or
delete duplicate_values_field_name dv from table_name ta where rowid <(select min(rowid) from
table_name tb where ta.dv=tb.dv);

How to use fetch statement in a loop?

981

---

Can a parameter be passed to a cursor?

1059

---

Is rowid unique in oracle?

949

---

How to name query output columns in oracle?

1141

---

interview questions with answer for cts

2541

---

Explain mutating triggers.

978

---

What is oracle instant client?

977

---

Respected sir, Please send me technical questions related to oracle apps..

1768

---

Explain about your project and its relation to the current job position you are applying to?

948

---

Where is the export dump file located?

1087

---

How do I connect to oracle?

983

---

What are the different pseudo commands? Explain in general?

1029

---

State and explain the different types of data models?

900

---

What is ceil and floor in oracle?

1018

---

What is a dead lock in oracle?

1054

---