Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE & DELETE?
- 16 Answers
- 45729 Views
- Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / ram kumar
1.Both are same but a little bit difference between them
2.Truncate removes all the rows in the table and it cannot
be rolledback bcoz its a DDL
3.Delete removes the particular record u want in the table
and it can be rolledback bcoz its a DML
4.Truncate is Unconditional and Delete is Conditional
Regards,
Ram Kumar...
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How to find 3rd highest salary of an employee from the employee table in sql?
how many tables will create when we create table, what are they? : Sql dba
What is trigger explain it?
what are the nonstandard string types? : Sql dba
What operating systems are supported by oracle sql developer?
What is a pl/sql block?
What is meant by user defined function?
In what condition is it good to disable a trigger?
How is a process of pl/sql compiled?
How to download oracle sql developer?
Are pl sql variables case sensitive?
Is sql injection illegal?
What is record type in pl sql?
Do we need commit after truncate?
What is execute immediate?
