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 are the types of trigger actions?

4 Answers   Zensar,

---

List out the oracle forms configuration files?

0 Answers  

---

What are the different types of Package Procedure ?

1 Answers  

---

Two popup pages can appear on the screen at a time ?

1 Answers  

---

What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?

2 Answers  

---

---

What are the triggers associated with a check box?

2 Answers  

---

Name the two files that are created when you generate the form give the filex extension ?

2 Answers  

---

From which designation is it preferred to send the output to the printed?

1 Answers  

---

What are the different Parameter types?

2 Answers  

---

What are the default extension of the files created by library module?

1 Answers  

---

Can we create two blocks with the same name in form 3.0 ?

1 Answers  

---

What is the difference between keystartup and pre-form ?

1 Answers  

---