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 the difference between DELETE and TRUNCATE?

Answer Posted / sanjay keserwani

we can go upto some number of records through delete while
in truncate we have to unoccupied all records.

Is This Answer Correct ?    4 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between the implicit and explicit cursors?

994


What are the datatypes available in pl/sql ?

1045


Do stored procedures prevent sql injection?

920


How to change sql*plus system settings?

997


What is difference between hql and native sql?

1093


What are different types of indexes?

960


How do you concatenate in sql?

975


What is a variable in sql?

953


How to combine two stored procedures in sql?

1124


What is an exception in PL/SQL? What are the two types of exceptions?

1194


When sql appeared?

1025


What is primary key secondary key alternate key candidate key?

982


define sql insert statement ? : Sql dba

977


Is truncate ddl or dml?

945


Is the primary key an index?

982