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 |
Can the query output be sorted by multiple columns in oracle?
What is a public synonym?
How to do clean up if create database failed?
Explain the difference between sap and oracle?
What is oracle rownum?
Is it possible to enter only time value into a column of a table in sql?
what are steps for interface? where is exchange rate defined in which table?
How to create lov dynamically at runtime & attach to text field?
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
What exactly do quotation marks around the table name do?
What WHERE CURRENT OF clause does in a cursor?
What are the attributes of the cursor?