Answer Posted / amit bhatnagar

Swati is cool. buth her queries are correct. you can either
take rowid >with subquery fetching minimum (rowid) else
Rowid < with subquery fething maximum (row id)

DELETE FROM <table_name> T1
WHERE T1.ROWID > (SELECT MIN(T2.ROWID)
FROM <table_name> T2
WHERE T2.<common column name> = T1.<common
column name>)

----------------------------

DELETE FROM <table_name> T1
WHERE T1.ROWID < (SELECT MAX(T2.ROWID)
FROM <table_name> T2
WHERE T2.<common column name> = T1.<common
column name>)
Good job Swati.. :)

what is pay run id ?

2140

---

testing tools?

2192

---

What do you understand by a set of books?

1053

---

What are the different components you should consider while defining a responsibility in oracle apps?

1048

---

what is the differences between internal requisition and internal sales order?

2615

---

what is the difference between request group and request security in oracle apps?

5806

---

what are the prerequisites for costing transactions?

3103

---

Tell me where we find the status of order information?

1106

---

What are file in oracle.

2188

---

What is sca and how is it useful?

1066

---

What do you understand by concurrent programs?

1044

---

Tell me how to find the custom directory in front end?

1066

---

How do you register report in oracle apps?

1040

---

Explain what are the tables of auto invoice?

1098

---

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2334

---