What is the difference between DELETE and TRUNCATE?
Answer Posted / satyajit patel
DELETE: DML, Manual Commit, Till not committed can be
rollback, can be applied for both row level as well as
table level, can be used in trigger, doesn't release memory.
TRUNCATE: DDL, auto commit, cann't rollback, applied table
level, cann't be used in trigger, releases memory.
In both cases structure remains.
Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
Are null values same as that of zero or a blank space?
How to order siblings in oracle hierarchy queries?
How do you copy a table in sql?
What is pl/sql language case sensitive?
What are the different parts of a package?
How would you reference column values before and after you have inserted and deleted triggers?
How do you know if a relationship is 2nf?
What are string functions in sql?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What is the maximum number of columns in sql table?
what is the difference between sql and t-sql? : Transact sql
how can we find the number of rows in a table using mysql? : Sql dba
explain the delete statements in sql
Explain the types of joins in sql?
how to enter characters as hex numbers? : Sql dba