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

Do you know where we can check the status of po?

1211

---

In oracle application how do you debug or trace errors?

1069

---

What are the different components of soa suite?

1161

---

What are do's and dont's of Interface?

2377

---

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

2615

---

What is sca and how is it useful?

1070

---

is it possible to run the interface without using oracle apps?

1941

---

please send me forms, xml pulisher questions,answers

2077

---

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

5820

---

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

1084

---

How many schemas we have? how many you have used?

2013

---

how do you describe O2C along with tables

2735

---

Can you explain the difference between architecture followed in 10g & 11g?

1027

---

tell my any difficult situtation you solved in your experience in your company?

2292

---

Can you define an erp system?

1102

---