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 / vasanth

Truncate
1.Truncate Can be DDL Command.
2.it can be rollback.
3.we cann't use Where clause.
4.truncate=delete+commit so we cann't rollback.
5.truncate delete all record from the table.
6.truncate is a DDL command and cannot be rollbackand all
memory space is released back to server.
7.speed faster.
8.do not chcek constraint.
Delete
1.Delete Can be DML Command.
2.it can be rollback.
3.we can use Where clause.
4.delete=delete-- so we can be rollback.
5.delete delete record from the table.
6.truncate is a DDL command and can be rollback and all
memory space is not released back to server.
7.speed slow.
8. chcek constraint.

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is semphore explian it?

2804


8. Supporting AP, AR and GL?

2301


Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1329


Explain how to close periods in ar. : oracle accounts receivable

1304


Explain about party and customer in ar : oracle accounts receivable

1201


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2210


can u give guidance abt packages of plsql

2162


what are the API of GL,PO,AP

2260


Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1083


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2064


Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2516


WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

2010


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

2226


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

1028


Explain prerequisites and post activities of oracle database installation

2122