Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between Truncate table / delete <table
name> purge
- 3 Answers
- 15553 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / papia
Truncate table removes all rows from the table and alos
releases the storage space and as it is a DDL statement so
no Rollback information is available
Delete statement also removes the row but does not release
the storage space
Truncate is faster than delete.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Why do we use sql constraints?
Can a view be mutating? If yes, then how?
What is cursor and why it is required?
What is the purpose of a secondary key?
Is left join inner or outer by default?
Does group by remove duplicates?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
what are properties of a transaction? : Sql dba
Is and as keyword in pl sql?
How to connect a sql*plus session to an oracle server?
what is the difference difference between procedure and packages
What is cartesian join in sql?
What does an inner join do?
What is the difference between a procedure and a function?
Define commit?
