Answer Posted / bharath

1.SELECT ROWID FROM TABLE T1
WHERE ROWID NOT IN (SELECT MIN(ROWID)
FROM TABLE T2 WHERE T1.KEY=T2.KEY);

THIS QUERY IS USEFUL WHEN WE HAVE A KEY VAL.
2.
i.CREATE TABLE NEW AS SELECT DISTINCT * FROM OLD;
ii.DROP TABLE OLD;
iii.RENAME NEW TO ORIGINAL;
THIS IS WHEN WE APPLY TO DELETE DUPLICATE ROWS..

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

1073

---

please send me forms, xml pulisher questions,answers

2117

---

How is choreography different from orchestration?

1143

---

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

1124

---

What do you understand by soa and what are the benefits of using this architecture?

1100

---

What do you understand by a set of books?

1120

---

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3071

---

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

2396

---

How can you achieve loose coupling in soa framework?

1236

---

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

2320

---

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

2622

---

Which oracle apps version you are very confident in?

1221

---

Tell me where we find the status of order information?

1140

---

how to print multi lay outs,muti currency,muti language in xml publisher

12304

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2637

---