diff between DELETE and TRUNCATE?.
- 14 Answers
- 18016 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
What is dual table oracle?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
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?
What is proxy method?
What is a relational database management system?
How does oracle handle read consistency?
How can we force the database to use the user specified rollback segment?
What is bind variable in oracle 11g?
11. Display the client number and name and the client number and name of the person who referred that client.
What happens to the indexes if a table is recovered?
What is the quickest way to fetch the data from a table?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
In the oracle version 9.3.0.5.0, what does each number shows?
How to convert a string to a date in oracle database?
