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;

How can we solve sql error: ora-00904: invalid identifier?

0 Answers  

---

Why use stored procedures?

0 Answers  

---

Does a join table need a primary key?

0 Answers  

---

What is the benefit of foreign key?

0 Answers  

---

What is execute immediate?

0 Answers  

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---

how to enter characters as hex numbers? : Sql dba

0 Answers  

---

Write the order of precedence for validation of a column in a table ?

2 Answers  

---

How show all rows in sql?

0 Answers  

---

What are the events on which a database trigger can be based?

0 Answers  

---

What is scalar and vector?

0 Answers  

---

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,

---