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;

Can procedure in a package be overloaded?

1 Answers   HCL,

---

Difference between a query and strored procedure?

4 Answers   Microsoft,

---

What is an emotional trigger?

0 Answers  

---

Explain the rollback statement?

0 Answers  

---

How is a process of pl/sql compiled?

0 Answers  

---

---

What does count (*) mean?

0 Answers  

---

How can you load microsoft excel data into oracle? : aql loader

0 Answers  

---

If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING

10 Answers   HCL, TCS,

---

What is the purpose of a secondary key?

0 Answers  

---

What is Primary Key?

4 Answers   Ramco,

---

Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

---

What is the difference between null value, zero, and blank space?

0 Answers  

---