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

How to load data from multiple files to single target?

563


What are the constraints are used in Ur project?

551


What is variable? What is Flow of variable?

620


how to load the data with one flat file and one rdbms table using joins?

617


What is Journalization and why we are using in ODI?

575


How many types of km's? And you what are the type's km are used in your project?

577


What is File steps?

621


What is CKM and when we will use this CKM?

566


What is the data quality in odi?

645


explain what is odi?why is it different from the other etl tools.

619


does odi support web services?

563


what is load plans and types of load plans?

618


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

687


What are the IKM types?

678


Have you created fact table and dimension tables?

642