What would you use to improve performance on an insert
statement that places millions of rows into that table?
Answer / saraswathi muthuraman
use Bulk collect insert and commit each set of transmission.
| Is This Answer Correct ? | 5 Yes | 0 No |
How can we create the complete backup of data in the oracle.
0 Answers IPEC, Satyam, SunTec,
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is a initialization parameter file in oracle?
24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
How to recover a dropped index?
12. Display the client name in upper case only and in lower case only.
How to get a list of all tables in the database?
what are different types of deletes?
Explain what are the different type of segments?
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
Please explain oracle data types with examples?