Interested to Buy Any Domain ? << Click Here >> for more details...
Differentiate between TRUNCATE and DELETE?
- 2 Answers
- 3052 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 |
How to use null as conditions in oracle?
Explain the truncate in oracle?
What is SQL access advisor in Oracle?
primary key is foreign key for the same table?
what is a Nested Loop join?
how to get last monday of a month?
Is there a combination of "like" and "in" in sql?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
What are the limitations oracle database 10g xe?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
How to set a transaction to be read only in oracle?
Oracle General 
