Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22522 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 are the logical operations?
What is dynamic proxy?
What do you know about normalization? Explain in detail?
How can I introduce multiple conditions in like operator?
What is a directory object?
What are a cluster and non-cluster index?
What happens if recursive calls get out of control?
How to drop a stored procedure in oracle?
Give the various rollback segment states.
What are the built-in functions used for sending Parameters to forms ?
How to call a stored function with parameters?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to use regular expression in pattern match conditions in oracle?
What privilege is needed for a user to insert rows to tables in another schema?
What are the different windows events activated at runtime ?
