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

in the package one interface got failed how to know which interface got failed if we no access to operator?

329


What are the types of Knowledge Modules?

295


How many types of dimensions in oracle?

276


Difference between 10g & 11g in odi?

469


What is Session Tasks?

304






Can migrate the one ORACLE DATA INTEGATOR studio to another ORACLE DATA INTEGATOR studio?

317


Difference between ETL and E_LT?

317


how to write the procedures in odi?

381


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

283


What is ELT? Or What is the difference between ODI and other ETL Tools?

314


What is J2EE Agent and port number?

301


what is oracle data integrator (odi)?

307


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

303


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

490


Have you created fact table and dimension tables?

341