also delete is a DML statement where as truncate is a DDL statement.

What is Difference Between delete and Truncate?

Question Posted / chandrakala

Answer Posted / chandrakala

also delete is a DML statement where as truncate is a DDL
statement.

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is pragma in pl sql?

1111

Can we call stored procedure in function?

959

What is pessimistic concurrency control? : Transact sql

1089

What is the difference between having and a where in sql?

1108

Where not exists in sql?

980

What is mutating trigger?

1024

what is union? : Sql dba

1028

How can a pl sql block be executed?

948

How are sql commands classified?

1089

where are cookies actually stored on the hard disk? : Sql dba

1030

What are the possible values for the boolean data field?

963

Why do we use cursors?

990

what are the t string functions available in tsql? : Transact sql

1009

What is error ora-12154: tns:could not resolve the connect identifier specified?

1081

What is pragma in sql?

1082