Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 65411 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / vijay rana
1.truncate is a DML command but Delete is a DDL Command
2.truncate is much faster then Delete
3.we can rollback delete but we cant rollback Truncate
4.we can not use where in truncate but we can use where with
delete
5.in case of truncate memory released immediately, but in
case of delete memory dosen release if we dont press commit.
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
8. Supporting AP, AR and GL?
What is the importance of batch source set up in ar? : oracle accounts receivable
Is there any link between pr form(purchse requisition)and po form(purchase order)
What is the use of lockboxes? : oracle accounts receivable
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
What is the difference between oracle media recovery and crash recovery?
