what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 58306 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / kavita sahu
1. Truncate is a DDL command and delete is a DML command
2. Truncate delete all records from table there is no
ROLLEDBACK it always Commit without giving the Commit
3. Truncate is much faster than Delete
4. Truncate you can't use where clause
DELETE you can use where clause
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
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?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
A scenario for amount correction & how to use amount correction functionality in AP invoices
which one is currently in used software cmpanies.
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
Explain the payment term in ar. : oracle accounts receivable
Difference between negative and positive adjustments : oracle accounts receivable
types of receipts and detail desription about recipts and tables effected by receipts?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
What is the mandatory setup in cyclecount ?
What is the sql query to find the employee who has Nth maximum salary?
What is an Oracle database Partial Backup?
how to replace not in with not exist?
