diff between DELETE and TRUNCATE?.
- 14 Answers
- 19697 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 |
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
why can't we assign not null constraint as table level constraint
Why is oracle so popular?
How to run create database statement again?
when loggined as SYSTEM,how to display all the users of database using sql query?
Explain about integrity constraint?
Please explan Why static query is more faster than dynamic query ?
Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Difference between varchar and varchar2 data types?
how to delete all duplicate records from a table using subquery?
Please explain compound trigger in oracle?
Oracle General 
