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 Difference Between delete and Truncate?

Answer Posted / kiran.

Delete(DML) : All records not possible to Delete at a time,
Where clause is allowed.
structure of the table is available.
Roll Back is possible.

Truncate(DDL): All records possible to Delete at a time,
Where clause is not allowed.
structure of the table is not available.
Roll Back is possible.
>Truncate Table<tablename>;

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to avoid using cursors?

1120


What is bulk collect in pl sql?

1088


What is sql injection owasp?

1060


What are the different parts of a package?

1115


Explain the methods used to protect source code of pl/sql.

1018


What is the difference between an inner join and an outer join?

1027


What is sqlexception in java?

989


What is 19 null in sql?

959


What is sql analyzer?

1017


What are the types of views in sql?

1098


what are the advantages a stored procedure? : Sql dba

976


What is data profiling in sql?

1076


What is a dirty read sql?

1137


who introduced sql?

1018


How do I view output in sql developer?

1085