Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 66490 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / rams
TRUNCATE:
1. it is a DML command.
2. by using truncate we can remove data in a table
permanantly.
3. we cant roll back the data.
4. it is faster than delete command.
DELETE:
1. it is a DDL command
2. by using delete command we can remove data in a table,
but we can rollback the data.
4. it is slower than the truncate command.
| Is This Answer Correct ? | 13 Yes | 21 No |
Post New Answer View All Answers
Can we modify approve purchase order?if yes what is navigation?
What is the difference between recovery and restoring of the oracle database?
What is autocashrule set? : oracle accounts receivable
HOW TO SPOT AHIERARCHY?
What is an Oracle database Partial Backup?
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
What is Tax Categories?
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
key flexfield structure
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
Difference between transaction type and transaction sources. : oracle accounts receivable
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
What do you mean by Oracle MEDIA RECOVERY?
What is the sql query to find the employee who has Nth maximum salary?
