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

What is difference between TRUNCATE & DELETE?

Question Posted / suneel

16 Answers
45802 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 do I get sql certification?

971

What does plv msg allows you to do?

1141

Does a primary key have to be a number?

963

How to execute a stored procedure?

1089

Which sql statement is used to return only different values?

1003

Is pl sql a scripting language?

1030

Can we rollback delete command?

985

What is primary key and foreign key?

960

What is meant by <> in sql?

978

What is difference between stored procedure and trigger?

1168

Explain the uses of control file.

1050

What is bind reference and how can it be created?

1020

What is sql data?

995

How do I truncate a sql log file?

1074

What do you understand by exception handling in pl/sql?

1035