diff between DELETE and TRUNCATE?.
- 14 Answers
- 18073 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
Answer Posted / thirupathi.l
delete is a dml command using this we can getback the records.
it will not call inmplicit commit.
perfomance slow in case of delete no.of records.
truncate is a ddl commnd.itwillcall implicit commit
we can't get back the record
performance good in case of deleting no.of records
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is an external table?
How to get the Installed Oracle Version Information ?
What is a dynamic performance view in oracle?
What is a proxy object?
What is a partition in oracle?
What is different types of joins?
Can we store images in oracle database?
Will you be able to store pictures in the database?explain.
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
what are steps for interface? where is exchange rate defined in which table?
When do I need to use a semicolon vs a slash in oracle sql?
definition of cluster and non-clustered index?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
Can we save images in a database and if yes, how?
How do I recompile a procedure in oracle?
