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 increment dates by 1 in oracle?

1133

---

Please explain drop constraint oracle?

1151

---

What is an oracle database?

1102

---

What is Redo Log Buffer in Oracle?

1273

---

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2140

---

How to grant create session privilege to a user in oracle?

1050

---

How to pass parameters to procedures?

1084

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1106

---

What are the differences between primary key and unique key?

1057

---

Why does for update in oracle 8 cause an ora-01002 error?

1043

---

How to use null as conditions in oracle?

1121

---

Explain integrity constraints?

1154

---

What is recovery manager(rman) backup in Oracle?

1229

---

what is the difference between restoring and recovering?

1051

---

material view and view disadvantages?

1117

---