Search:     Advanced search
Browse by category:
C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers
Home / Oracle / Database / Q: What is difference between TRUNCATE & DELETE ?

Q: What is difference between TRUNCATE & DELETE ?
Print
Email to friend
Add comment
Views: 1703
Votes: 8
Comments: 0
A: TRUNCATE commits after deleting entire table i.e., can not be rolled back. Database triggers do not fire on TRUNCATEDELETE allows the filtered deletion. Deleted records can be rolled back or committed.Database triggers fire on DELETE. synchronized.  
 
Others in this Category
document What is SQL Server Agent?
document What is Log Shipping?
document Q: What is difference between UNIQUE and PRIMARY KEY constraints?
document Q: What is CYCLE/NO CYCLE in a Sequence ?
document Q: how to know the days or months or years between two employees in emp table?
document What is Catalog Views?
document What are primary keys and foreign keys?
document What is Data Compression?
document Q: What is the difference between Rule based optimization and Cost based optimization in Oracle SQL queries?
document What is PRIMARY KEY?
» More articles


RSS
Powered by KBPublisher (Knowledge base software)