Answer Posted / sunil

delete emp where empno not in(select distinct empno from emp);

For example we have duplicates in empno column then write
query like above...whatever column u want u can write..

What is the usage of merge statement?

911

---

Does facebook use oracle?

821

---

Is a rollback possible to any savepoint?

782

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2174

---

How to view existing locks on the database?

799

---

What is the relation of a user account and a schema?

895

---

How to use "while" statements in oracle?

976

---

What is memory advisor in Oracle?

845

---

How many types of synonyms in Oracle?

852

---

What is truncate oracle?

746

---

What is Undo Management Advisor in Oracle?

832

---

How to assign a tablespace to a users in oracle?

811

---

query optmization techniques and quwry analyser+projects+ppts

2178

---

When do you get a .pll extension in oracle?

932

---

How index is implemented in oracle database?

790

---