Interested to Buy Any Domain ? << Click Here >> for more details...
what is purge command
explain about oracle performance tuning
- 2 Answers
- 26679 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 is sql catalog?
What is package in pl sql with an examples?
what is union, minus and interact commands? : Sql dba
Does sql view stored data?
What is the maximum number of triggers, you can apply on a single table?
What are tables and fields in the database?
How delete all records from table in sql?
What does plv msg allows you to do?
How do I partition a table in sql?
Explain correlated query work?
What are the different parts of a package?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is character functions?
Does truncate table reset auto increment?
What is a natural join?
