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 a value set? List its various types.

0 Answers  

---

In one flat file i got headers and lines data how you can write control file now ?

1 Answers   KPMG,

---

In sequence i want to 11 and 15th values how we will write?

0 Answers  

---

How can a process be deployed in soa?

0 Answers  

---

How can u call a standard interface program from sql or pl/sql code?

3 Answers   Satyam,

---

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

3 Answers   Scan Steel,

---

What is REF Cursor?

19 Answers   Infosys, Intelligroup,

---

Give a overview on Aol

2 Answers   Zensar,

---

hi all.i am in need of some sample codes for oracle apps manufacturing interfaces.If any of u have,plz send it to me . Thank you.

1 Answers   BirlaSoft,

---

mention the interface tables for item open interface and open transaction interface and also their respective production tables.

1 Answers   Scan Steel,

---

What is Value Set?

2 Answers   Accenture,

---

How to know the number of invoices generated for one PO from front end (navigation)?

1 Answers   Oracle,

---