Interested to Buy Any Domain ? << Click Here >> for more details...
What would you use to improve performance on an insert
statement that places millions of rows into that table?
- 1 Answers
- 3622 Views
- I also Faced
- E-Mail Answers
Answer / saraswathi muthuraman
use Bulk collect insert and commit each set of transmission.
| Is This Answer Correct ? | 5 Yes | 0 No |
What is a Sequence ?
What is the maximum number of CHECK constraints that can be defined on a column ?
what is meant by magic query
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is a cursor in oracle?
How to define a record variable to store a table row?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
definition of cluster and non-clustered index?
How to load data from external tables to regular tables?
What is the exact use of Collections?
State some uses of redo log files?
Explain the use of record option in exp command.
Oracle General 
