Answer / sandeep

the above answer will work ifonly one dplicate row is there,
if there are more than one duplication.
then

delete from table_name where rowid not in(select min(rowid)
from table_name group by column_name having count(*)>1)

Answer / jagan

delete from tablename a where rowid not in(select max(rowid)
from tablename b where a.rowid=b.rowid)

What is a difference between pre-select and pre-query?

1 Answers   iFlex,

---

What is a canvas-view?

1 Answers  

---

What is the use of break group?

1 Answers  

---

how to create parameterised form in oracle 10g? and create another form from the value of the form? AND how to assign value to a parameter? sincerly your mamun

2 Answers  

---

What are the different display styles of list items?

1 Answers  

---

Can you change the alert messages at run-time?

2 Answers  

---

from where do u receive the information to develop report

0 Answers  

---

List the buil-in routine for controlling window during run-time?

1 Answers  

---

What is Post-Block?

1 Answers  

---

How to create LOV in Oracle forms?

2 Answers   Accenture, Polaris,

---

What are the built-ins used for Getting cell values?

1 Answers  

---

How do you control the constraints in forms ?

1 Answers  

---