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 I copy :old and :new pseudo-records in/to an oracle stored procedure?

0 Answers  

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

Is sql microsoft?

0 Answers  

---

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,

---

What is correlated sub-query?

7 Answers   Oracle,

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

0 Answers   IBM,

---

Is left join faster than inner join?

0 Answers  

---

Is primary key a clustered index?

0 Answers  

---

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,

---

what is SCALAR Queries?

2 Answers   ITC Infotech,

---

what is sub-query? : Transact sql

0 Answers  

---

how are mysql timestamps seen to a user? : Sql dba

0 Answers  

---