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

1099

---

List the various types of value set.

1083

---

What are the benefits of using soa architecture?

1253

---

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2618

---

How can we import the data into a database using sql * loader?

1196

---

How is choreography different from orchestration?

1137

---

Tell me how to debug the report?

1125

---

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

5903

---

Plz anybody send me Technical specification for AP Interface

2564

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2634

---

List the types of flexfield?

1044

---

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

1111

---

Do you know what is applysys in oracle application database schema, what is apps?

1179

---

Can you differentiate between mediator and osb?

1146

---

How do you register report in oracle apps?

1099

---