Interested to Buy Any Domain ? << Click Here >> for more details...
Differentiate between TRUNCATE and DELETE?
- 2 Answers
- 2931 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vikas
delete is slow because it creates log file while performing delete operations.We can recover data which is removed by using delete command by using rollback.
Truncate is fast because it does not create any log file while performing delete operation.We can not recover data which is removed by using truncate command.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain the importance of .pll extension in oracle?
After update how do u know how many records got updated
what is Single Byte Overhead...?
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
how to find find & delete duplicate rows from two different tables?
What is the quickest way to export a table to a flat file?
how to tune oracle sql queries pls tell me step by step. urgent pls
Explain mutating triggers.
What is a proxy class?
What happens to the data files if a tablespace is dropped?
How to retrieve first and last records from a table?
when i run my query on yesterday it is fast but today it is slow why?
Oracle General 
