Answer Posted / 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.

What is data manipulation language?

1193

---

How do I view a sql database?

1023

---

Explain what is a field in a database and record in a database?

1097

---

how many ways to get the current time? : Sql dba

1009

---

What is trigger in pl sql?

1004

---

How do you update f as m and m as f from the below table testtable?

1860

---

How is sql used in oracle?

1010

---

What is the difference between having and a where in sql?

1110

---

How do I find duplicates in the same column?

1089

---

What are the advantages of pl sql over sql?

1026

---

What is duration in sql profiler trace?

1085

---

What is the difference between join and natural join?

930

---

Can a primary key be a foreign key?

1023

---

how to dump a table to a file with 'mysqldump'? : Sql dba

1038

---

what is “go” in t-sql? : Transact sql

1108

---