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
What do you mean by group by clause?
How do you bind variables in oracle?
Explain a synonym?
How to convert character types to numeric types?
What is the minimum client footprint required to connect c# to an oracle database?
How to grant create session privilege to a user in oracle?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What is a Garbage Collection? and what is full recursive Garbage collection?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
What are the original export and import utilities?
What is the use of oracle?
What is Reduced List of Values?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How to rename an index in oracle?
How to call a stored function with parameters?
