the delete command log all the stmts in the transaction log and the trunc

What is the difference between DELETE and TRUNCATE?

Question Posted / althaf

Answer Posted / althaf

the delete command log all the stmts in the transaction log
and the truncate command dont log the stmts.

Is This Answer Correct ?

8 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is database migration?

963

What are the basic sql commands?

1086

What is the execution plan in sql?

1018

What does the base_object_type column shows in the user.triggers data dictionary view?

1046

Show the cursor attributes of pl/sql.

1044

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

1220

Is mariadb nosql?

1039

What are the types of index in sql?

1063

What does where 1 1 mean in sql?

1035

how to shutdown mysql server? : Sql dba

1094

How do I view stored procedures?

969

How do I kill a query in postgresql?

1104

What is sap sql anywhere?

1066

How to read/write files from pl/sql?

1035

How do I save a sql query?

1008