Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between Truncate table / delete <table
name> purge
- 3 Answers
- 15822 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / murthy
TRUNCATE:-IT WILL DELETE ALL THE EXISTING RECORDS IN A TABLE
SYNTAX:-TRUNCATE TABLE <TABLE NAME>
DELETE:-IT WILL DELETE THE RECORDS IN A TABLE DEPENDINFG ON
THE GIVEN CONDITION.
SYNTAX:-DELETE FROM <TABLE NAME> WHERE <CONDITON>
PURGE:-AFTER PERFOMING DROP OPERATION THE TABLES WILL STORE
AT UNDO LOGS SO TO DELETE THE DATA COMPLETELY FROM TAHE
DATA BASE WE WILL PURGE THE RECYCLEBIN.
SYNTAX:-PURGE RECYCLEBIN.
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
what is 'mysqldump'? : Sql dba
What is the maximum number of triggers, you can apply on a single table?
What is sql dialect?
What is the difference between microsoft access and sql server?
What is an invalid partition table?
Explain 3 basic parts of a trigger.
What are synonyms in sql?
What is a memo field?
What is pls integer?
What is clustered and nonclustered index in sql?
Can you load data into multiple tables at once? : aql loader
Are there any features that are decommissioned in 11g that are not present in 11g?
how to select first 5 records from a table? : Sql dba
Enlist the advantages of sql.
What is nvl?
