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

Difference between delete & truncate?

Answer Posted / venki

Delete means when we deleted the row and columns in the table.Then we can give the rollback command again it will regain the data to the table
Truncate means when we deleted the row and columns in the table.it will be deleted permanently rollback command won't work here

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 load plans and types of load plans?

556


What is the data quality?

577


What are the knowledge modules types?

545


what is profile in odi?

603


What is the normalization?

536


Which profile required to access Models in Designer tool?

660


What is the scd? and Types of SCD?

574


How you find which the latest record in SCD type2 transformation is?

541


can we implement package in package?

537


Tell me some differences between ODI 10g and ODI 11g?

509


What flow of MSExcel in odi?

539


What is variable? What is Flow of variable?

564


Have you created sequence? When will you use?

508


What is Memos?

529


What are the types of data contol?

563