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

3. Steps in UAT?

2432


How would you determine who has added a row to a table?

2316


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

4446


What is the sql query to find the employee who has Nth maximum salary?

5331


What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1047


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.

2192


which gives Oracle R12 Financial training in delhi please give me answer its urgent?

2499


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?

2189


default triggers available for reports

2211


Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1145


while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2135


8. Supporting AP, AR and GL?

2311


How to clone the database using RMAN back

2239


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

2331


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2281