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 do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4523

---

Can we save images in a database and if yes, how?

1065

---

What is null value in oracle?

1097

---

What is enter substitution variable in oracle?

1052

---

How to see free space of each tablespace?

1036

---

What is an index associated with a constraint?

1040

---

What is the implicit cursor in oracle?

1105

---

What is a trigger and what are its types in oracle?

1073

---

What privilege is needed for a user to create views in oracle?

1050

---

What is bulk load in oracle?

1070

---

How do I call oracle stored procedures that take no parameters?

1116

---

Give the advantages and disadvantages of clusters.

1051

---

What do database buffers contain?

1033

---

Explain the use of constraints option in exp command.

1048

---

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

2141

---