which statement is running fastly ie insert or delete?
- 13 Answers
- 19584 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sandeep desai
Its definitely Delete.
Becuase
When Delete operation is being performed then Oracle
doesnot actualy permanently remove the data from data block
but rather marks that particular data block as unusable.
Whereas when concerned to Insert Oracle needs to insert the
new values into Datablocks.
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / sanal kumar
Delete runs faster than insert
coz whle during delete command,it only removes the records
from the table and the space alocated for the records
remains still..but for insertion,need to allocate the space
and insert the records in data blocks..
| Is This Answer Correct ? | 5 Yes | 1 No |
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What is the maximum number of CHECK constraints that can be defined on a column ?
Can we call procedure inside function in oracle?
What is the difference between hot backup and cold backup in oracle?
What privilege is needed for a user to create tables in oracle?
What is partitioned table in Oracle?
What is archive log in Oracle?
8. Display the client name and order date for all orders using the natural join keywords.
Is it possible to split the print reviewer into more than one region ?
What is the difference between view and materialized view in Oracle?
How to open and close an explicit cursor in oracle?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
Oracle General 
