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

Truncate is the ddl command we can't get back, the delete
command we can delete the table not the fields.
In the turncate we can not get fields also these the main
differance.,
i think so

Is This Answer Correct ?    13 Yes 43 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1145


What is auto invoicing? Explain : oracle accounts receivable

1122


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

1028


What do you mean by hz_ in customer tables? : oracle accounts receivable

1206


Explain the process of recievables in oracle financials. : oracle accounts receivable

1151


Is there any link between pr form(purchse requisition)and po form(purchase order)

2712


which one is currently in used software cmpanies.

2143


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

2002


WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2944


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


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?

1332


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


Why more redos are generated when the oracle database is in begin backup mode?

1116


What is the mandatory setup in cyclecount ?

2744


HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2507