Answer Posted / swati

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>)

testing tools?

2301

---

How can a process be deployed in soa?

1334

---

What is the concept of soa governance?

1319

---

How do you register report in oracle apps?

1134

---

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

2132

---

What are file in oracle.

2286

---

Tell me how to debug the report?

1172

---

what is pay run id ?

2241

---

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2177

---

What are the Standard Reports and Forms in HRMS?

2377

---

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

2437

---

how do you describe O2C along with tables

2833

---

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

5976

---

What are the benefits of using soa architecture?

1323

---

what are the different transaction clauses in AR?

2167

---