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

Truncate Statement:
1.Deletes all the rows from the table.

Delete Statement:
1.Delete a specific row.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to clone the database using RMAN back

2138


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

975


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

4385


How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2105


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

2150


where the dff data will be stored

2333


What is Restricted Mode of Instance Startup in Oracle?

1140


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.

3863


What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

1216


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

6678


What is autocashrule set? : oracle accounts receivable

1287


What view would you use to determine free space in a tablespace?

2166


Are These Dff's Flexible?

1110


Could you please let me know the interfaces in OM / FA??

2182


Difference between negative and positive adjustments : oracle accounts receivable

1009