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

In Truncate only data are remove from table
where as in delete structure of table are delete.

Is This Answer Correct ?    3 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

2491


What is auto invoicing? : oracle accounts receivable

1150


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

5314


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

2063


How would you determine what sessions are connected and what resources they are waiting for?

2123


what are the tools used for oracle 10g in real time.

2435


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

1282


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

1169


What is auto invoicing? Explain : oracle accounts receivable

1122


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

2255


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.

3929


1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17625


How to clone the database using RMAN back

2221


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


I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2511