what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 58208 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
Give two methods you could use to determine what DDL changes have been made.
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
which one is currently in used software cmpanies.
How would you determine who has added a row to a table?
What is the difference between oracle media recovery and crash recovery?
What is the mandatory setup in cyclecount ?
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
please send me oracle pl/sql exp resume. and also faqs...
What is the use of lockboxes? : oracle accounts receivable
Why more redos are generated when the oracle database is in begin backup mode?
Explain the use of table functions.
can u give guidance abt packages of plsql
default triggers available for reports
