diff between DELETE and TRUNCATE?.
- 14 Answers
- 19806 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to grant create session privilege to a user in oracle?
What is the difference between primary key and unique key and foreign key in oracle?
What are the numeric comparison operations?
Where are the settings stored for each instance in oracle?
How to apply filtering criteria at group level in oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What happens if the update subquery returns multiple rows?
Explain the use of record option in exp command.
What is the difference between a user and a schema in oracle?
Is a rollback possible to any savepoint?
State all possible different index configurations a table can possibly have?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What is set operator oracle?
What is snapshot is too old? Give and example for better understand.
What are the benefits of ordbms?
