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 systems can odi extract and load data into?

589


What is Journalization and why we are using in ODI?

571


What is Sequences?

627


What is the data quality in odi?

643


What are the types of profiles in ODI?

595


How many types of v variables'? Where will appear for variables in odi?

571


How many types of dimensions in oracle?

578


What is the load plans in odi?

631


what is the odi console?

625


How to move objects from DEV to QA and QA to PROD Environments?

710


what is profile in odi?

649


What is the use of the Service Knowledge module?

588


does odi support web services?

560


how to implement the logic in procedures if the source side data deleted that will reflect the target side table?

685


how to implement data validations?

589