-Original Message-
Sent: Saturday, February 22, 2003 7:54 AM
To: Multiple recipients of list ORACLE-L
You can read more abt it in PL/SQL User's Guide and Reference - Chapter 4 -
Collections and Records !
anyway, below is the simple code to copy data from emp table. note that,
after u
I tried this way and infact bulk collect took about 1 minutes more than
my current case?
Any thoughts
thanks
-Original Message-
Sent: Saturday, February 22, 2003 7:54 AM
To: Multiple recipients of list ORACLE-L
You can read more abt it in PL/SQL User's Guide and Reference -
:
Sent by: Subject: RE: slow insert
[EMAIL PROTECTED
PROTECTED]
obile.com cc:
Sent by: Subject: RE: slow insert
[EMAIL PROTECTED
You can read more abt it in PL/SQL User's Guide and Reference - Chapter 4 -
Collections and Records !
anyway, below is the simple code to copy data from emp table. note that,
after u fetch from the cursor, u have to check for the notfound condition at
the end. say, the emp table has 15 rows and u
if u r having oracle 8.1.7 EE or higher, try using bulk inserts ! that
surely will speed up !
and of course, u surely might have thought of APPEND hint
dropping/disabling indexes etc.
-Original Message-
Ravindra
Sent: Friday, February 21, 2003 3:08 PM
To: Multiple recipients of list
Yes I am usng 8.1.7 EE.How do I use bulk inserts..Any docs or links on metalink plss?
-Original Message-
Sent: Friday, February 21, 2003 3:34 PM
To: Multiple recipients of list ORACLE-L
if u r having oracle 8.1.7 EE or higher, try using bulk inserts ! that
surely will speed up !
and