Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between Truncate table / delete <table
name> purge
- 3 Answers
- 15647 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
Which version of sql do I have?
What is dml and ddl?
Can we call dml statement in function?
What is the use of sql trace?
How to raise user-defined exception with custom sqlerrm ?
How do I view a view in sql?
How do I view tables in mysql?
What is the sql query to display the current date?
Explain the uses of control file.
What is substitution variable in pl sql?
How to load data with sql*loader?
What is the difference between view and stored procedure?
What are data types in pl sql?
What is file based approach?
What is scalar and vector?
