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 / kotravel. b

TRUNCATE DELETE
1 cannot be 1 can ba RB
roll back


2 faster than 2 slower than truncate
delete


3 it releses the stroge 3 it does not releses the stroge
sp sp
spaces

Is This Answer Correct ?    75 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Restricted Mode of Instance Startup in Oracle?

1140


can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2313


if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2014


please send me oracle pl/sql exp resume. and also faqs...

2445


I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1956


What are different types of transactions in ar? : oracle accounts receivable

1217


8. Supporting AP, AR and GL?

2263


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2221


What do you mean by Oracle MEDIA RECOVERY?

1161


what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2166


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

1281


Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1019


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

1218


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


what is difference between inner join & nested query or subqueries

2962