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 >> Oracle >> Oracle AllOther
  2. Suggest New Category

what is the difference between TRUNCATE and DELETE command
in SQL

Question Posted / mkjmkumar

Answer Posted / mkjmkumar

TRUNCATE

1. It is DDL.
2. Speed is faster
3. Do not Check Constraints.
4. Roll Back is not possible.
5. Can not use where clause

DELETE

1. It is not a DDL
2. Speed is slow
3. Check constraints, If Exists then shoe error.
4. We can rollback .
5. User Where Clause

Is This Answer Correct ?    78 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of lockboxes? : oracle accounts receivable

1210

What is auto invoicing? : oracle accounts receivable

1166

we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

2529

What is auto invoicing? Explain : oracle accounts receivable

1128

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2517

What is the difference between recovery and restoring of the oracle database?

1226

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1281

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

2195

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

1134

What is the difference between conversions and interfaces? : oracle accounts receivable

1242

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1297

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3943

What is the disk migration? what is the steps involved in oracle disk migration?

1225

how to write customizations in po

1622

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2523