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 bind reference and how can it carate?

1 Answers  

---

I HAVE A REPORT LAYOUT LIKE THIS RUNDATE -FIELD DEPTNO-FIELD ------------------------------------------------------------ ------------------- EMPNO-----ENAME------SAL-----COMM----MGR----- ------------------------------------------------------------ ------------------ ------- ------------ -------- -------- -------- MY REQUIREMENT IS I WANT DEPTNO 10 VALUES IN ONE PAGE,DEPTNO 20 VALUES IN ONE PAGE,AND 30 IN ONE PAGE. I WANT LIKE THIS ....

4 Answers  

---

if u develop report do u ask for anything from u r team leader

1 Answers  

---

What are the default parameter that appear at run time in the parameter screen?

1 Answers  

---

What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

1 Answers  

---

---

What do you understand by lov and how can it be used?

0 Answers  

---

Which of the above methods is the faster method?

1 Answers  

---

What is the difference when confine mode is on and when it is off?

1 Answers  

---

What use of command line parameter cmd file?

1 Answers  

---

How do you control the constraints in forms ?

1 Answers  

---

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

1 Answers  

---

running a report from Form or other Report , The Parameter Form Page will be Display first . I don?t want to display the screen . What I have to do ?

1 Answers   Convergys,

---