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

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

1358

---

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

2023

---

How is choreography different from orchestration?

1174

---

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

2471

---

Explain what are the tables of auto invoice?

1194

---

Explain oracle apps architecture.

1299

---

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

2085

---

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3729

---

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

1125

---

Tell me where we find the status of order information?

1194

---

What is count(*) from po_vendors(any table)?

1134

---

What is the concept of soa governance?

1316

---

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

2131

---

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

2361

---

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2152

---