diff between DELETE and TRUNCATE?.
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 happens if recursive calls get out of control?
Is oracle an open source?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What are the roles of dba?
Where is the export dump file located?
How to handle a single quote in oracle sql?
What are the different types of partitions in oracle?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What is a trigger oracle?
How would you begin to troubleshoot an ORA-3113 error?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
What is the difference between I and G in Oracle?
Explain rename?
List the various oracle database objects?
what are the default admin accounts in Oracle 10g ?