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

what is exact difference between drop and truncate table.

Question Posted / samad

Answer Posted / samad

ya its correct sowjanya

DROP - delete objects from the database
TRUNCATE - remove all records from a table, including all
spaces allocated for the records are removed in this
rollback is not possible

DELETE - deletes all records from a table, the space for the
records remain rollback is possible

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to recover a dropped table in oracle?

983

Give the advantages and disadvantages of clusters.

996

What is a nested table?

1003

How to load data through external tables?

1070

How to display row numbers with the records?

1024

How to convert raw data type into text in oracle? Explain

950

Is there an oracle sql query that aggregates multiple rows into one row?

930

Does oracle database need java?

940

What are oracle functions?

973

What is varray?

1033

What is oracle sid?

886

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2126

What is Java Pool in Oracle?

1089

How to delete multiple rows from a table in oracle?

1002

How can you merge two tables in oracle?

936