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 are the Types of repositories in ODI?

630


What is CDC and explain complete CDC process flow?

634


how to handle exceptions?

649


Explian File steps in ODI?

669


What are the IKM types?

734


Tell me step by step to enable Journalization?

677


what is the odi console?

681


How to create sequence in odi?

692


suppose having unique and duplicate but I want to load unique record one table and duplicates one table?

787


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

626


What is the scd? and Types of SCD?

672


Which profile required to access ODI Console?

641


How to load data from multiple files to single target?

607


What is an agent and What are the types of agents?

672


What is a scenario in odi?

625