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 >> SQL PLSQL
  2. Suggest New Category

What is difference between TRUNCATE & DELETE?

Question Posted / rampratap singh

Answer Posted / rampratap singh

Truncate is DDL so it does not create rollback segments,

where as DELETE is DML and creates rollback segments.

Truncate removes/reset the high watermark.
Delete does not do that.

Is This Answer Correct ?    10 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we update views in sql?

938

What is bulk compiling in pl/sql.?

1127

What is the difference between joins?

1037

Explain exception handling in pl/sql?

1033

What is trigger explain with example?

1033

Can cursors be part of a trigger body?

1637

What is the difference between a procedure and a function?

1106

What is sqlerrd?

966

How do I remove duplicates in two columns?

1057

How run sql*plus commands that are stored in a local file?

1059

What is sap sql anywhere?

1068

How delete all data from all tables in sql?

944

What is union and union all keyword in sql?

1031

how to include character strings in sql statements? : Sql dba

1067

Can we use joins in subquery?

1158