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...

diff between DELETE and TRUNCATE?.

Answer Posted / sandeep desai

Some more additions

With Truncate command Oracle sets the High Water Mark to
Zero
whereas
With Delete command this doesn't happen since data is not
released from the memory

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens if recursive calls get out of control?

1067


Is oracle an open source?

1066


What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2263


What are the roles of dba?

1061


Where is the export dump file located?

1133


How to handle a single quote in oracle sql?

1031


What are the different types of partitions in oracle?

962


In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1835


What is a trigger oracle?

1079


How would you begin to troubleshoot an ORA-3113 error?

2071


Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1855


What is the difference between I and G in Oracle?

1085


Explain rename?

968


List the various oracle database objects?

1047


what are the default admin accounts in Oracle 10g ?

959