What is the difference between DELETE and TRUNCATE?
Answer Posted / kalyana chakravarthy
Delete is associated with rollback segments like U can undo
it before committing and U have a choice of deleting a
specific row or rows where as
Truncate is not associated with rollback segments ie U cant
undo it and U cant delete a row/rows of ur choice
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How do you declare a constant?
How to run sql statements with oracle sql developer?
Is sql the best database?
Whis is not false in primary key?
Write a query to find the names of users that begin with "um" in sql?
Explain the purpose of %type and %rowtype data types with the example?
How many types of triggers exist in pl/sql?
What is online transaction processing (oltp)?
What is nosql db?
How to raise user-defined exception with custom sqlerrm ?
What can sql server reporting services do?
how to create a test table in your mysql server? : Sql dba
what's the difference between a primary key and a unique key? : Sql dba
What is java sql connection?
how to return query output in html format? : Sql dba