Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 23087 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
Answer Posted / sandeep desai
Some more additions
With Truncate command Oracle sets the High Water Mark to
Zero
whereas
With Delete command this doesn't happen since data is not
released from the memory
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to assign data of the deleted row to variables?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
Explain the different normalization forms?
How to start an oracle instance?
What is Library Cache in Oracle?
How to use "while" statements in oracle?
How oracle handles dead locks?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is a package ? What are the advantages of package ?
How to set a transaction to be read only in oracle?
What is a cognitive schema?
How do I find my oracle client driver version?
How can Oracle users be audited?
what is the scenario where you take the database to NoArchivelog mode?
What is bind variable in oracle 11g?
