Answer / koti

Ganesh ,You are right very good.
delete from emp t
where rowid != ( select min(rowid)
from empno
where empno = t.empno );
---------And other answers are not right .

Answer / madhuapps

delete from t1 tl
where tl.rowid >
( select min(tl2.rowID) from t1 tl2
where tl.col1 = tl2.col1
and tl.col2 = tl2.col2)

Answer / satyan

simple query
step 1
select rowid,column1,column2,column3 from table name where
condition;
step 2
delete from table name where rowid = '........'

Answer / ganesh

delete from emp t
where rowid != ( select min(rowid)
from empno
where empno = t.empno );

what is mutating table and mutating error and how to solve that?

3 Answers  

---

In what situation u create the BPA.

2 Answers   Accenture,

---

what are version control tools used in oracle apps?

1 Answers   Cap Gemini, Sony,

---

What are the Import Programs We need to run after creating Interface table for all modules

1 Answers   Accenture,

---

How to send the e-mail notification in XML Pub Report?

2 Answers   Accenture, Oracle,

---

what is Flex mode and Confine mode?

2 Answers   Rapidigm,

---

is UOM maintained at master level or organization level or both?

3 Answers   Scan Steel,

---

What is Summary columns?

1 Answers  

---

what are the different calculation columns available in reports?

1 Answers  

---

what is meant by Drill Down in Discoverer report? why it will be use?

3 Answers   Oracle,

---

HOW CAN U KNOW THE STAUS OF PO?

1 Answers   TCS,

---

how can i print random rows in plsql table

0 Answers   Fujitsu, KPIT,

---