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)

from where do u receive the information to develop report

0 Answers  

---

How do u give the list of values in bind parameter

1 Answers   Zensar,

---

Any attempt to navigate programatically to disabled form in a call_form stack is allowed?

1 Answers  

---

What do you understand by oracle forms and why are they required?

0 Answers  

---

how to send sms to mobile phone from oracle forms.

1 Answers   HP, Tech Mahindra,

---

can u call procedure or function is sq l query in reports

1 Answers  

---

Is it possible to attach same library to more than one form?

1 Answers  

---

Is the After report trigger fired if the report execution fails?

2 Answers  

---

difference between repeating frame and frame

3 Answers   IBM,

---

HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.

2 Answers  

---

What are the display styles of an alert?

1 Answers  

---

How can you hide the report in Apps?

1 Answers  

---