Answer / apurva

Purge command is used to clear the recycle bin.
It can also be used with drop command
ex. drop table <tablename> purge;
this command will clear away the table from database as
well as from the recycle bin. After firing of purge command
you cannot retrive the table using flashback query.

Answer / pooja

Use the PURGE statement to remove a table or index from
your recycle bin and release all of the space associated
with the object, or to remove the entire recycle bin, or to
remove part of all of a dropped tablespace from the recycle
bin.
PURGE RECYCLEBIN;

how a reference cursor works?what all adnvantages are gained with it..specify the situation?

4 Answers   TCS,

---

What is a pdo connection?

0 Answers  

---

What is the usage of NVL?

7 Answers   Infosys, Micro Infotek,

---

What is the purpose of the primary key?

0 Answers  

---

What is a database trigger ? Name some usages of database trigger ?

4 Answers  

---

---

how to find 5th row ?

10 Answers  

---

What is dynamic sql in pl sql?

0 Answers  

---

What is the basic structure of PL/SQL ?

6 Answers  

---

How many null values can be inserted in a coulmn whihc is unique constraint

8 Answers   Flextronics,

---

In pl/sql, what is bulk binding, and when/how would it help performance?

0 Answers  

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

---

what is sql and plsql

6 Answers  

---