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 do I turn a list into a table?

0 Answers  

---

What is bulk collect in pl sql?

0 Answers  

---

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,

---

Can we join tables without foreign key?

0 Answers  

---

What is microsoft t sql?

0 Answers  

---

how to use 'mysql' to run sql statements? : Sql dba

0 Answers  

---

discuss about myisam key cache. : Sql dba

0 Answers  

---

Can we use two order by clause in query?

0 Answers  

---

full outer join syntax

5 Answers  

---

What are some predefined exceptions in pl/sql?

0 Answers  

---

Explain architecture of sql server notification services?

0 Answers  

---

What does the base_object_type column shows in the user.triggers data dictionary view?

0 Answers  

---