Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22026 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 the disadvantage of User defind function?
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 import one table back from a dump file?
What is tns name?
Explain about your project and its relation to the current job position you are applying to?
types of indexes and the rationale behind choosing a particular index for a situation.
what are the advantages of running a database in archive log mode?
What is a tns service name?
What are privileges and grants?
How do we get field details of a table?
What are the differences between char and varchar2 in oracle?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
Can we save images in a database and if yes, how?
Explain the use of ignore option in imp command.
What is the difference between pre-select and pre-query?
