What would you use to improve performance on an insert
statement that places millions of rows into that table?
- 1 Answers
- 3021 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 |
Explain the use of Merge statement in oracle 11g
How to start instance with a minimal initialization parameter file?
What is a lookup table in oracle?
I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.
How can I introduce multiple conditions in like operator?
What is Public Database Link ?
What is concurrency in oracle?
query to find the maximum no persons with same age(age colomn) from emp table
What is the difference between alert log file and trace file ?
When does a Transaction end ?
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
Oracle General 
