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 is differance unique key and primary key.

7 Answers   EDS,

---

What is procedure explain with example?

0 Answers  

---

Is natural join and inner join same?

0 Answers  

---

Why left join is used in sql?

0 Answers  

---

What is the difference between drop and truncate commands?

0 Answers  

---

---

What are inner and outer joins examples of both?

0 Answers  

---

What are user defined stored procedures ?

3 Answers   BirlaSoft,

---

1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?

2 Answers  

---

What are different joins used in sql?

0 Answers  

---

How do you delete data from a table?

0 Answers  

---

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

0 Answers  

---

What is Difference Between delete and Truncate?

9 Answers  

---