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 a pragma statement?

0 Answers  

---

write a query find which rows of a table is updated on 2 days before?

3 Answers   TCS,

---

How many functions are there in sql?

0 Answers  

---

What are the different types of functions in sql?

0 Answers  

---

difference between SQL and C

1 Answers   Indus Software Technologies,

---

---

explain access control lists. : Sql dba

0 Answers  

---

which types of join is used in sql widely? : Sql dba

0 Answers  

---

how many values can the set function of mysql take? : Sql dba

0 Answers  

---

What is index example?

0 Answers  

---

What is dml with example?

0 Answers  

---

select sal from emp group by sal

3 Answers   TCS,

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

0 Answers  

---