what is purge command
explain about oracle performance tuning
- 2 Answers
- 25028 Views
- Accenture, eCentric Solutions, I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 37 Yes | 3 No |
Post New Answer View All Answers
What are the ways on commenting in a pl/sql code?
what is the different between now() and current_date()? : Sql dba
what is sql server agent? : Sql dba
How do you change a value in sql?
Explain the the delete statements in sql?
Can we insert data into view?
Where can I learn sql for free?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What is pl sql script?
Can instead of triggers be used to fire once for each statement on a view?
What operating systems are supported by oracle sql developer?
What is rank dense_rank and partition in sql?
What is primary key and foreign key?
Can sql developer connect to db2?
Why procedure is used in sql?
