what is purge command
explain about oracle performance tuning
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
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What are character functions?
What are sql objects?
What are commit, rollback, and savepoint?
What is application trigger?
How can get second highest salary in sql?
What is varchar used for?
what are rollup and cube in t-sql? : Transact sql
Does sql require a server?
When are we going to use truncate and delete?
How many types of relationship are there?
Explain dml and ddl?
What is structural independence and why is it important?
How many types of sql are there?
Is vs as in pl sql?