Answer Posted / aseem k

Tried and tested:
Table d:
7
8
7

DELETE FROM D WHERE ROWID IN (
SELECT DISTINCT MIN(ROWID) FROM D
WHERE DEPTNO IN
(SELECT DEPTNO FROM D GROUP BY DEPTNO
HAVING COUNT(DEPTNO)>1))

various types of hints and their usage

2643

---

How to experiment a data lock in oracle?

1013

---

Does oracle database need java?

956

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2221

---

Give the advantages and disadvantages of clusters.

1012

---

What is Undo Management Advisor in Oracle?

1058

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1951

---

Can we write dml statement in function in oracle?

1043

---

What is different types of joins?

986

---

How to do clean up if create database failed?

992

---

How to create additional tablespaces for an new database?

989

---

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2102

---

What is the difference between 10g OEM and 11g OEM?

936

---

Which is better Oracle or MS SQL? Why?

6295

---

How many categories of data types in oracle?

987

---