which statement is running fastly ie insert or delete?
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 |
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
State and explain the different types of data models?
What is flashback in Oracle?
20. Using a set operator, display the client number of all clients who have never placed an order.
What is oracle and what are its different editions?
primary key is foreign key for the same table?
How to define Data Block size ?
How to check your oracle database 10g xe installation?
How would you begin to troubleshoot an ORA-3113 error?
How are Indexes Update ?
What are the different types of modules in oracle forms?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));