diff between DELETE and TRUNCATE?.
- 14 Answers
- 19718 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
Answer Posted / p.baskar
DELETE is DML Command, TRUNCATE is DLL Command.
DElete used to particular record or, all records from table.
But TRUNCATE only relete the all records.
Ee can rollback the DELETE Command, But we cant rollback the
TRUNCATE
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What does sharding mean?
In the oracle version 9.3.0.5.0, what does each number shows?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What is materialized view in Oracle?
What is a trigger oracle?
How to write a query with a right outer join in oracle?
What is a view and how is it different from a table?
Why do we use coalesce function in oracle?
What is a cursor in oracle?
How does oracle handle read consistency?
how the indexes are stored in the Oracle Database?
What is tns entry?
What is integrity and what is constraint??Explain with example
what are bitmap indexes? How does they work?
How to use "startup" command to start default instance?
