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;

What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

---

How many sectors are in a partition?

1 Answers  

---

what is union, minus and interact commands? : Sql dba

1 Answers  

---

What are the advantages of pl sql over sql?

1 Answers  

---

What is the difference between syntax error and runtime error?

1 Answers  

---

Can one improve the performance of sql*loader? : aql loader

1 Answers  

---

what is the difference between a web-garden and a web-farm? : Sql dba

1 Answers  

---

What is difference between hql and native sql?

1 Answers  

---

explain the difference between bool, tinyint and bit. : Sql dba

1 Answers  

---

explain what is mysql? : Sql dba

1 Answers  

---

What is a 'instead of trigger'?

3 Answers   Eenadu, TCS,

---

What is a primary key called that is made up of more than one field?

1 Answers  

---