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

Differences between package and loadplans?

288


In topology manager where the data are stored?

324


Which profile required to access Models in Designer tool?

382


What is the data quality in odi?

281


What are the Types of Scd's?

303






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

313


Step by step explain for the Flat file?

322


What is SKM and when we will use this SKM?

347


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

393


What is the use of the Service Knowledge module?

297


How to send the emails for odi?

396


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

295


What are the types of Generic profiles types in ODI?

437


If you are working Microsoft excel, which type of file you used .excel or .csv?

273


what we specify the in XML data server and parameters for to connect to xml file?

369