Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22661 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 is recovery manager in Oracle?
What are the oracle differences between nvl and coalesce
What are the set operators union, union all, minus & intersect meant to do?
What is the sql query to concatenate column values from multiple rows in oracle?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
Can group functions be mixed with non-group selection fields?
How to recover a dropped table in oracle?
How to start your 10g xe server?
What is oracle datasource?
Explain an integrity constrains?
Explain what are synonyms used for?
What are joins, explain all types of joins?
What happens to indexes if you drop a table?
How to rollback the current transaction in oracle?
What is a read only transaction in oracle?
