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 / anup.wilson

Answer Posted / anup.wilson

hii every one ... i want to say that delite is --dml and
truncate is ddl ..nxt thing about roll back ..through
delete we roll back untill unless we are not COMMIT IT..
IF WE COMMIT AFTER DELETE ..WE CANT ROLL BACK IT
...

Is This Answer Correct ?    15 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

A scenario for amount correction & how to use amount correction functionality in AP invoices

2128

What is the use of lockboxes? : oracle accounts receivable

1198

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

1169

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4438

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2325

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

2404

what are basic modules required to implement oracle application in any oraganisation?

2202

Give two methods you could use to determine what DDL changes have been made.

6762

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

2507

What is Restricted Mode of Instance Startup in Oracle?

1190

Are These Dff's Flexible?

1164

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

2094

What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

2168

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

1122

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2255