adspace


  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

diff between DELETE and TRUNCATE?.

Question Posted / thirupathi.l

Answer Posted / thirupathi.l

delete is a dml command using this we can getback the records.
it will not call inmplicit commit.
perfomance slow in case of delete no.of records.
truncate is a ddl commnd.itwillcall implicit commit
we can't get back the record
performance good in case of deleting no.of records

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Design database draw er diagram for a certain scenario ?

4655

How to write a left outer join with the where clause in oracle?

1152

How to start an oracle instance?

1103

How to put more than 1000 values into an oracle in clause?

1114

How to select all columns of all rows from a table in oracle?

1131

How to use values from other tables in update statements using oracle?

1157

What is oracle latest version?

1173

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1955