Truncate is a DDL command and hence cant be rolled back where as delete is

What is difference between TRUNCATE & DELETE?

Question Posted / deva

Answer Posted / deva

Truncate is a DDL command and hence cant be rolled back
where as delete is DML command and thus can be rolled back
if not necessary.

Is This Answer Correct ?

31 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to Execute a Package in PL/SQL.?

576

Does access use sql?

554

How do I find duplicates in a single column in sql?

530

What is column?

543

What is example of database?

512

Why do we use joins in sql?

497

What is trigger and stored procedure in sql?

552

How is sql used in oracle?

577

what is dbms? : Sql dba

541

Explain correlated query work?

588

what is the command used to fetch first 5 characters of the string? : Sql dba

1132

What is sqlcontext?

546

Can we insert delete data in view?

540

Which is better trigger or stored procedure?

496

What is sql basics?

573