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

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

1216


What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1327


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

1168


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

2002


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

1767


can u give guidance abt packages of plsql

2162


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

1026


how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2391


difference of using cursor for loop and open,fetch,close.which one is better

1796


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.

3927


What is chargeback invoice? How do we create it? : oracle accounts receivable

1326


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2208


What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1190


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

2281


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7655