Interested to Buy Any Domain ? << Click Here >> for more details...
which statement is running fastly ie insert or delete?
- 13 Answers
- 18966 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sudheer
INSERT BECAUSE IN DELETE STATEMENT TO TAKE THE TIME TO DELETE BECAUSE THAT DATA WHERE IT HAVING TO IT SERACH.BUT INSERT NOT LIKE THAT WHEN U WRITE THE COMMAND ITS NOT TO TAKE LONGER TIME...........
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
What is backup in Oracle?
Explain what are the advantages of views?
How to select all columns of all rows from a table in oracle?
How can you merge two tables in oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...
10 Answers Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,
what is the difference between rollback & commit? can a foreign key has null value?
How to connect asp pages to oracle servers?
How many memory layers are in the shared pool?
How does one get the view definition of fixed views/tables?
Select the Nth lowest value from a table?
Which Oracle App Is Most Popular One ?
Oracle General 
