diff between DELETE and TRUNCATE?.
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 maximum number of triggers that can be applied to a single table?
What is a read write transaction in oracle?
What is oracle analytical function?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How to write date and time interval literals in oracle?
What is tns entry?
What is the sid in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
what is meant by magic query
What is the data type of dual table?
Explain drop constraint oracle?
What is a view and how is it different from a table?
How to rename an index in oracle?
Can we protect our pl/sql source code?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?