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

TRUNCATE:
1. it is a DML command.
2. by using truncate we can remove data in a table
permanantly.
3. we cant roll back the data.
4. it is faster than delete command.

DELETE:
1. it is a DDL command
2. by using delete command we can remove data in a table,
but we can rollback the data.
4. it is slower than the truncate command.

Is This Answer Correct ?    13 Yes 21 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we modify approve purchase order?if yes what is navigation?

2068


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

1830


WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

2066


How many segment are present in Oracle Manufacturing

2369


What is auto invoicing? : oracle accounts receivable

1234


i want to know about the javaBean.what is its purpose and how it can use in Forms.

2504


I need a Technical evaluation between Oracle and SAP ? please do a need ful.

2037


now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2334


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2124


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2147


HOW TO SPOT AHIERARCHY?

2342


What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1477


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

2281


Explain the payment term in ar. : oracle accounts receivable

1149


what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1169