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)

System.effective_date system variable is read only True/False

1 Answers  

---

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

1 Answers  

---

can you convert or reverse engineer a fmx back to a fmb file?

0 Answers  

---

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 is the use of Validation triggers in Reports?

2 Answers   GE,

---

What is responsibility and how u attach How to create user and how u attach with responsibility.

0 Answers   Zensar,

---

What do we mean by record group in oracle forms?

0 Answers  

---

What is a canvas in oracle forms?

0 Answers  

---

What is lexical parameter ?

2 Answers   Zensar,

---

List the windows event triggers available in Forms 4.0?

1 Answers  

---

how to pass 2 parameters from one form to other in oracle applications?

1 Answers  

---

List out the oracle forms configuration files?

0 Answers  

---