Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 23088 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
What is a trigger oracle?
How can windows applications connect to oracle servers?
Is oracle the best database?
Can we commit inside a function in oracle?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is columnar storage what is the advantage?
Explain self joins in oracle?
what is the difference between restoring and recovering?
How can you merge two tables in oracle?
When do I need to use a semicolon vs a slash in oracle sql?
How to create a stored program unit?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
Explain the use of rows option in exp command.
How to store only time; not date and time?
what is the scripts in data base?
