Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

How to start instance with a minimal initialization parameter file?

1031

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2225

How to rebuild an index in oracle?

1019

How to sort the query output in oracle?

1018

What is null value in oracle?

1091

What is Virtual Private Database in Oracle?

1075

What are the ansi data types supported in oracle?

942

What is an anonymous block?

1228

What are advantages of dateset in datastage?

2257

How can you use check constraints for self referential integrity?

958

How do you store pictures in a database?

997

Explain table?

1104

How to loop through a cursor variable?

1078

Give the various exception types.

985

How can we find out the duplicate values in an oracle table?

1034