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

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

diff between DELETE and TRUNCATE?.

Question Posted / sandeep desai

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 is bulk collect in oracle?

954

Explain about achiever in sql?

979

What is sequence?

1008

Explain drop constraint oracle?

988

What is primefaces used for?

1006

What are the various oracle database objects?

1090

What is the difference between "as" and "is" in an oracle stored procedure?

931

Explain cascading triggers.

1011

Why is oracle database so popular?

947

How to export several tables together?

986

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2319

What are triggers in oracle?

977

Difference between inner join vs where ?

977

How to connect to a remote server?

1051

How to define a data field as not null?

1059