Answer Posted / ron

don't have a simple answer, you'll need to use oracle utils,
util_file and packages:
read about it in detail to download and running package at
website below:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:728625409049

hope this helps.

Explain integrity constraint?

1109

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

934

---

What is a nested table?

1007

---

How many types of synonyms in Oracle?

1066

---

How can we delete duplicate rows in a table?

929

---

Explain the importance of .pll extension in oracle?

956

---

How to delete a column in an existing table?

1020

---

How to start a specific oracle instance?

991

---

How to list all tables in your schema?

992

---

How to drop an index in oracle?

1022

---

How to connect to the server with user account: sys?

971

---

How to retrieve data from an explicit cursor?

1009

---

What is a nvl function? How can it be used?

960

---

What is difference between cartesian join and cross join?

1018

---

Explain about functional dependency and its relation with table design?

954

---