Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE & DELETE?
- 16 Answers
- 44986 Views
- Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / rampratap singh
Truncate is DDL so it does not create rollback segments,
where as DELETE is DML and creates rollback segments.
Truncate removes/reset the high watermark.
Delete does not do that.
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
Can we call a function containing dml statements in a select query?
What is the difference between instead of trigger and after trigger?
What is cursor in pl sql with examples?
What is optimistic concurrency control? : Transact sql
How do you update a table in sql?
How can I delete duplicate rows?
Is time a data type in sql?
what is the syntax for using sql_variant_property? : Transact sql
What is the trigger in sql?
Why stored procedure is faster than query?
Can we commit in trigger?
What is oracle sql called?
What is sql*loader and what is it used for? : aql loader
What is left inner join in sql?
What is break?
