Answer Posted / ch. nageswar subudhi

For delete the DUPLICATE RECORD from Table by using this
Query:

DELETE FROM EMP E
WHERE E.ROWID <>(SELECT MIN(ROWID) FROM EMP E2 WHERE
E.EMP_NO=E2.EMPNO);

Differentiate between sga and pga.

1165

---

What is sqlerrm?

939

---

How to get each name only once from an employee table?

1116

---

What is the process of copying data from table a to table b?

1093

---

Explain normalization and what are the advantages of it?

953

---

tell me about various levels of constraint. : Sql dba

1035

---

Is foreign key mandatory?

1005

---

What do you mean by table in sql?

991

---

How do I write a cron which will run a sql query and mail the results to agroup?

981

---

What are some predefined exceptions in pl/sql?

1168

---

What is the difference between syntax error and runtime error?

1142

---

What are sql commands?

1014

---

Which type of cursor is used to execute the dml statement?

958

---

How do you write a complex sql query?

1082

---

differentiate between float and double. : Sql dba

1060

---