What is difference between TRUNCATE & DELETE?
Answer Posted / oracle_tigress
difference between truncate and delete
1.truncate removes rows in one execution..delete removes
rows one by one so truncate is fast..
2.truncate does not creates logs and hence canot be
rolledback and hence is a DDL stmt..DELETE creates rollback
segment hence can be rolled back and hence is a DML stmt.
3.truncate doesnot allow for conditional remove of records
(all records has to remove) DELETE allows conditonal remove
of records(where cluase etc can be used.)
4.triggers are not fired on truncate stmt but trgieers are
fired on DELETE stmt..
Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
What is the difference between function, procedure and package in pl/sql?
Can you join views in sql?
What is inner join in sql?
Which is better trigger or stored procedure?
where are cookies actually stored on the hard disk? : Sql dba
How much ram can sql express use?
Is sql workbench free?
Define sql delete statement.
What is rownum and rowid?
What is the purpose of a secondary key?
What are tables in sql?
What are sql functions? Describe the different types of sql functions?
How do I partition in sql?
What are %type and %rowtype for?
What is denormalization in a database?