Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 23068 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / chaitanyabilla
delete-low water mark level
truncate-high water level
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sahaja mallarapu
Delete is a DML command.
Truncate is a DDL command.
Using delete we can delete specific rows by applying some
condition.
using truncate all rows are deleted. we cant apply any
condition here.
deleted rows can be rollbacked.
truncated rows cant be rollbacked.
memory occupied by deleted rows cant be reused.
memory occupied by truncated rows can be reused.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / padma
delete comd is used to delete not a specific record rather
all records without affecting the structure of the records
truncate comd is used to delete all the records from
existing table,retaining the structure o that table.
by using delete comd v can rollback all the delete
records .it is record level cmd
wherease truncate cmd v cannot rollback. it is table
level cmd
| Is This Answer Correct ? | 1 Yes | 3 No |
How different is ms access and oracle?
What are triggers?Where are they used?
What are the different types of databases?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
what is Single Byte Overhead...?
What is a trigger and what are its types?
how to store only time in a data base table
What would you use to improve performance on an insert statement that places millions of rows into that table?
which clause we are not used in where clause?
What is archive log in Oracle?
What is the best way to do multi-row insert in oracle?
Oracle General 
