Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 65572 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / pavan_1981
truncate is ddl command.its faster than delete as it doesnt
have go through the rollbacks etc.truncate being a ddl is
auto commit.we can only truncate the whole table(cant use
where clause).once table is truncated we cant rollback the
changes.when a table is truncated the memory occupied is
released.that id the water mark is adjusted.
delete is a dml command and can be rolled back.is slower
than truncate as it is dml has to go through rollback
segments etc.we can use where clause with delete.when a
table is deleted memory occupied is not released ans also
the water mark is not adjusted.
| Is This Answer Correct ? | 153 Yes | 11 No |
Post New Answer View All Answers
how to write customizations in po
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
What is the difference between conversions and interfaces? : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
i want to know about the javaBean.what is its purpose and how it can use in Forms.
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
Explain the use of table functions.
What are different types of transactions in ar? : oracle accounts receivable
HOW TO SPOT AHIERARCHY?
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
What is Restricted Mode of Instance Startup in Oracle?
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
