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
- 3649 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 the dynamic sql in oracle?
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
Explain the family trees and connection by clause
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
What is the purpose of save points in oracle database?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
How to pass parameters to procedures in oracle?
how do u know the total no of rows in a table?
What are the different pseudo commands? Explain in general?
What are the types of trigger in oracle?
How to define a variable to match a table column data type?
what is the syntax of INSERT command?
Oracle General 
