Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE & DELETE?
- 16 Answers
- 45790 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
can a stored procedure call itself or recursive stored procedure? : Sql dba
What are sql procedures?
How do we accept inputs from user during runtime?
what is the difference between primary key and unique key? : Sql dba
Are there any features that are decommissioned in 11g that are not present in 11g?
Can primary key be changed?
What is a system versioned table?
What is the difference between pl and sql?
Can we use the cursor's to create the collection in PL/SQL?
How do you truncate?
what is 'mysqlcheck'? : Sql dba
What is scope and visibility in PL/SQL?
What happens when a trigger is associated to a view?
Is join and inner join the same?
Why self join is used in sql?
