Answer Posted / aseem k

Tried and tested:
Table d:
7
8
7

DELETE FROM D WHERE ROWID IN (
SELECT DISTINCT MIN(ROWID) FROM D
WHERE DEPTNO IN
(SELECT DEPTNO FROM D GROUP BY DEPTNO
HAVING COUNT(DEPTNO)>1))

Explain cascading triggers.

1121

---

How to write text literals in oracle?

1118

---

What is Data Dictionary Cache in Oracle?

1243

---

What are the attributes that are found in a cursor?

1120

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1092

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2384

---

How to specify default values in insert statement using oracle?

1153

---

What is bind variable in oracle 11g?

1096

---

Difference between the “verify” and “feedback” command?

1427

---

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1159

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1968

---

what are archived logs?

2260

---

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1135

---

How to loop through a cursor variable?

1128

---

How to drop an existing view in oracle?

992

---