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 / p.baskar

Answer Posted / p.baskar

DELETE is DML Command, TRUNCATE is DLL Command.

DElete used to particular record or, all records from table.
But TRUNCATE only relete the all records.

Ee can rollback the DELETE Command, But we cant rollback the
TRUNCATE

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is oracle used?

887

Please explain compound trigger in oracle?

1005

What is a private synonym?

1537

How to use subqueries with the exists operator in oracle?

979

What is BBED in Oracle?

1098

master table and child table performances and comparisons in Oracle ?

2083

What is an external table?

965

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2514

What is a trigger and what are its types?

1132

Why use resource manager in Oracle?

1062

How to create a table index?

1077

How do we create privileges in oracle?

997

what is the difference between functional dependecy and multilevel dependency?

2425

How to use group functions in the select clause using oracle?

1034

IS it possible to built the oracle database without setting the kernal parameters?

2286