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 TRUNCATE and DELETE command
in SQL

Answer Posted / vijay rana

1.truncate is a DML command but Delete is a DDL Command

2.truncate is much faster then Delete

3.we can rollback delete but we cant rollback Truncate

4.we can not use where in truncate but we can use where with
delete

5.in case of truncate memory released immediately, but in
case of delete memory dosen release if we dont press commit.

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between transaction type and transaction sources. : oracle accounts receivable

1067


What is Tax Categories?

2159


What is auto invoicing? : oracle accounts receivable

1234


Difference between negative and positive adjustments : oracle accounts receivable

1159


What is the difference between oracle media recovery and crash recovery?

1211


how to replace not in with not exist?

3798


hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

2281


what are the tools used for oracle 10g in real time.

2491


What is an Oracle database Full Backup?

1174


Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1407


I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2305


How many segment are present in Oracle Manufacturing

2369


as a technical developer in oracle applications which type errors feced in your experience sofar

2232


can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2435


Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1830