Difference between delete & truncate?
- 1 Answers
- 944 Views
- TCS, I also Faced
- E-Mail Answers
Answer / 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 |
what is load plans and types of load plans?
0 Answers Hexaware, Seventhsense Technologies,
What is the use of the Service Knowledge module?
What are the Types of repositories in ODI?
What is ELT? Or What is the difference between ODI and other ETL Tools?
Explain for repository?
how to load the data with one flat file and one rdbms table using joins?
0 Answers Seventhsense Technologies,
Difference between delete & truncate?
When you used JKM ?
How you find which is the latest record in SCD type2 transformation?
What is load plan and types of load plans in ODI?
What is variable? What is Flow of variable?
Have you attend the client meetings?
Oracle General 
