Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vikas
When we use truncate data deletes permanently and can not recover.Truncate is fast because it not writes any thing in log file while perform deleting operations.
Delete is used to removed table data and it can be recover by using rollback . Delete is slow because it create log file before performing the delete operation.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create a new user account in oracle?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
How to use in conditions in oracle?
what is the difference between functional dependecy and multilevel dependency?
Explain how are indexes update?
How to get execution path reports on query statements?
How can Oracle users be audited?
How to update a table row with a record?
How to use subqueries with the exists operator in oracle?
Explain rename?
How to omit columns with default values in insert statement in oracle?
what are the advantages of running a database in archive log mode?
What happens if you lost a data file?
How to create lov dynamically at runtime & attach to text field?
How to do paging with oracle?
