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 display styles of list items?

1 Answers  

---

in before report trigger SRW.user_exit(FND_Userinit) what will do

3 Answers  

---

Which is the cheapest and quality Oracle Education provider in Bangladesh?

1 Answers  

---

What is coordination Event?

1 Answers  

---

List the system variables related in Block and Field?

1 Answers  

---

How can you create Lexical parameter n Bind parameter in Reports ?

1 Answers   GE, SVSS,

---

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

0 Answers  

---

What are the unrestricted procedures used to change the popup screen position during run time ?

1 Answers  

---

What is summary column in Oracle Reports ?

5 Answers   GE,

---

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

0 Answers   GE,

---

What are the ways to monitor the performance of the report?

1 Answers  

---

Explain about stacked canvas views?

2 Answers  

---