Differentiate between TRUNCATE and DELETE?
- 2 Answers
- 2114 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 |
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
what r tyhe major differences between oracle 9i & 10g?
is database gud carrier option??
How does oracle handle read consistency?
How to define a record variable to store a table row?
Explain view?
What is a public synonym?
What is the oracle implicit cursor?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What is forall Statement ?
What do you understand by a database object?
How to call a sub procedure?
Oracle General 
