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 constraints are used in Ur project?

276


Which profile required to access solution in Designer tool?

292


Can you joined two sources without common column?

327


if the source have total 15 records with 2 records are updated and 3 records are newly inserted at the target side we have to load the newly changed and inserted records

275


what is load plans and types of load plans?

276






can we implement package in package?

289


What is the data quality?

303


What is a scenario in odi?

291


Have you attended the client meetings?

315


Explain for repository?

304


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

379


What is the use solutions?

325


What is Sequences?

333


How to load data from file to file and what are the KM's required for this requirement?

343


Have you created sequence? When will you use?

289