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

How to name query output columns in oracle?

1130

---

What is oracle open database communication (odbc)?

959

---

Why is oracle used?

879

---

how the indexes are stored in the Oracle Database?

2213

---

How to use in conditions in oracle?

995

---

What is the dynamic sql in oracle?

1007

---

How many data types are supported?

1022

---

Explain the use of parfile option in exp command.

988

---

What is save point in oracle database?

1239

---

What is redo log?

1004

---

what's query optimization and without use of IN AND Exist can we get another way data from query

2086

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2574

---

How to retrieve values from data fields in record variables?

1033

---

How do I spool in oracle?

939

---

What is SQL Tuning Advisor in Oracle?

1106

---