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 the usage of the confine mode in Layout Editor ?

2 Answers   Convergys,

---

In what sequence do triggers get fired by oracle forms?

0 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  

---

I want to learn the Oracle configurator(OracleApps)can any one tell best institutes in Hyderbad

2 Answers  

---

What are the built-ins that are used for setting the LOV properties at runtime?

1 Answers  

---

---

What are the types of trigger actions?

4 Answers   Zensar,

---

How many Flexfields are there in AR and what are they ?

1 Answers  

---

What is the difference between keystartup and pre-form ?

1 Answers  

---

Name the different triggers associated with oracle forms having a master-detail relationship.

0 Answers  

---

If a break order is set on a column would it effect columns which are under the column?

1 Answers  

---

HOW TO MAKE A MATRIX REPORT MANUALLY WITH SINGLE GROUPT QUERY OR MULTIPLE GROUP QUERY ?

1 Answers   Jaguar, TCS,

---

can you change the default value of the radio button group at run time?

1 Answers  

---