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

What is indexing oracle sql?

1108

What is recursive stored procedure?

1102

What is a ddl command?

1093

What are the different sql commands?

1075

What is basic structure of pl sql?

1074

What is sql procedures and functions?

1012

How do I partition a table in sql?

1136

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1142

How many sql databases can you have on one server?

1087

What is an example of translating a date into julian format?

1124

What does the acronym acid stand for in database management?

1032

how to drop an existing index in mysql? : Sql dba

1069

How to run sql statements with oracle sql developer?

1074

Is sql free?

974

What is a temporal data type?

1054