which statement is running fastly ie insert or delete?
- 13 Answers
- 16194 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / ram bhajan tiwari
Delete
Because during delete statement pointer has no need to
find the address of memory but in insert statement the
pointer has first point the memory then it can insert so it
will take more time than delete.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to test null values?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Please explain drop constraint oracle?
How to experiment a data lock in oracle?
How to use "for" statements in oracle?
Why is oracle database so popular?
what is the scenario where you take the database to NoArchivelog mode?
What is a package in oracle?
What is the use of aggregate functions in oracle?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is the difference between hot backup and cold backup in oracle?
What is a data lock in oracle?
11. Display the client number and name and the client number and name of the person who referred that client.
What is integrity and what is constraint??Explain with example
How do I uninstall oracle 11g?
