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...

What is the difference between DELETE and TRUNCATE?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explian rowid, rownum? What are the psoducolumns we have?

1045


How do I turn a list into a table?

1007


How to run sql statements through the web interface?

1089


Can we use loop in sql?

1010


Why is the cursor important?

1077


What is relationship? How many types of relationship are there?

1260


Explain the the update statement in sql?

1098


Describe sql comments?

1106


Does pdo prevent sql injection?

988


Can we rename a column in the output of sql query?

1038


Explain lock escalation? : Transact sql

1268


How do I run a pl sql program?

1189


how to include numeric values in sql statements? : Sql dba

1145


How to disable a trigger name update_salary?

1307


How can you load microsoft excel data into oracle? : aql loader

1213