diff between DELETE and TRUNCATE?.
- 14 Answers
- 19740 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
Why is oracle database so popular?
What is different types of joins?
Where do we use decode and case statements?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
Explain a segment?
How to create an oracle testing table?
What is object data modeling?
What privilege is needed for a user to delete rows from tables in another schema?
Is oracle a relational database?
What is execute immediate in oracle?
What are the general rules on data consistency?
How to put more than 1000 values into an oracle in clause?
Why do you create or replace procedures rather that drop and recreate.
What privilege is needed for a user to query tables in another schema?
What is the quickest way to export a table to a flat file?
