You will be hard pressed to write anything in Pro*C/OCI which beats
SQL*Loader performance.
<$0.02>
And if you did get something together which was speed equivalent, you
could have probably done it all faster using a combination of shell,
SQL*Loader, and PL/SQL.
</$0.02>
--
Ron Reidy
Oracle DBA
chris wrote:
> I'm sure this is a silly design question, but I'm curious as to why
> I'd ever want to do use embedded SQL from my Bourne Shell script, when
> it's easier to just write the output to a .ctl file and run sqlldr?
>
> Any idea which is more efficient? Have I missed anything?
>
> thanks.
>
> chris
Received on Mon Apr 28 2003 - 19:34:11 CDT
