we can go upto some number of records through delete while in truncate we

What is the difference between DELETE and TRUNCATE?

Question Posted / sanjay keserwani

Answer Posted / sanjay keserwani

we can go upto some number of records through delete while
in truncate we have to unoccupied all records.

Is This Answer Correct ?

4 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is mutating error in pl sql?

1001

What is view? Can we update view

1411

What is the difference between distinct and unique in sql?

920

How to pipe multiline string to isql?

998

What is the use of sql trace?

936

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1129

what are the differences between binary and varbinary? : Sql dba

1017

Why stored procedure is faster than query?

1035

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

937

What is rank () in sql?

924

What is a .db file?

960

How to fix oracle error ora-00942: table or view does not exist

994

what is collation? : Sql dba

1130

Is pl sql useful?

966

what is timestamp in mysql? : Sql dba

1051