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;

I want to execute a piece of code before calling a procedure. How to achieve it?

1 Answers   Oracle,

---

what is the difference between $message and $$message? : Sql dba

0 Answers  

---

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

---

What is AUTH_ID and AUTH_USER in pl/sql ?

0 Answers   INDUS,

---

How do you use a while loop in pl sql?

0 Answers  

---

How to fetch records from a partitioned table?

2 Answers   HSBC,

---

What is the benefit of foreign key?

0 Answers  

---

What is oracle sql called?

0 Answers  

---

What is Overloading of procedures ?

4 Answers   Amdocs,

---

When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,

---

What pl/sql package consists of?

0 Answers  

---

what is difference between stored procedures and application procedures,stored function and application function?

1 Answers  

---