What is difference between TRUNCATE & DELETE?
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
What is full join?
Is vs as in pl sql?
Explain select statements in sql?
what happens if you no create privilege in a database? : Sql dba
What is the purpose of the partition table?
What is coalesce in sql?
What does desc stand for?
what are local and global variables and their differences? : Sql dba
What is scope and visibility in PL/SQL?
How do I count duplicates in sql?
What does stand for in sql?
how many ways we can we find the current date using mysql? : Sql dba
What is the difference between stored procedure and view?
how many triggers are allowed in mysql table? : Sql dba
How to find 3rd highest salary of an employee from the employee table in sql?