| |
GeekInterview.com > Interview Questions > Oracle > SQL Plus
| Print | |
Question: What is difference between TRUNCATE & DELETE
Answer:
Answer posted by Scott on 2005-05-25 18:30:04: TRUNCATE is a DDL command and cannot be rolled back. All of the memory space is released back to the server.
DELETE is a DML command and can be rolled back.
Both commands accomplish identical tasks (removing all data from a table), but TRUNCATE is much faster. |
| May 05, 2005 18:30:04 |
#1 |
| Scott |
Member Since: Visitor Total Comments: N/A |
RE: What is difference between TRUNCATE & DELETE
|
TRUNCATE is a DDL command and cannot be rolled back. All of the memory space is released back to the server.
DELETE is a DML command and can be rolled back.
Both commands accomplish identical tasks (removing all data from a table), but TRUNCATE is much faster. |
| |
Back To Question | |
