truncate: --------- truncate is a ddl command. ddl commands having auto

What is difference between TRUNCATE & DELETE?

Question Posted / suneel

16 Answers
46357 Views
Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS, I also Faced
E-Mail Answers

Answer Posted / suneel

truncate:
---------
truncate is a ddl command.
ddl commands having auto commit.

delete:
-------
delete is a dml command.
dml commands not having auto commit.

Is This Answer Correct ?

4 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How exception handling is done in advance pl/sql?

1019

what is try_catch block in procedure

1806

Is primary key an index?

1032

What is the difference between the sql*loader and import utilities? : aql loader

1086

What is record variable?

1034

What is the purpose of my sql?

1008

Can we have two clustered index on a table?

1075

What is pl sql block structure?

1085

What is clause in sql?

1176

What are conditional predicates?

1114

What is sql engine in oracle?

1036

How is sql used in oracle?

1037

What is sql and db2?

1050

What is the difference among union, minus and intersect?

1045

What is dml with example?

1154