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 dialect in sql?

987

How exception is different from error?

1065

How do I send sql query results to excel?

1111

What is sql injection vulnerability?

1005

What is the command used to fetch the first 5 characters of a string?

1257

what is the difference between a web-garden and a web-farm? : Sql dba

1139

What is index example?

1044

Why procedure is used in sql?

1084

What is the importance of sqlcode and sqlerrm?

1394

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1272

How do you modify a table in sql?

1162

What is the difference between a primary key and a unique key?

1106

Does sql require a server?

1055

Where is all the data on the internet stored?

1056

How do I run pl sql in sql developer?

1170