Re: PL/SQL, Pro *C, SQL *Loader

You might find that Pro*C is you _only_ choice, depending on the parsing you require.

I'd use it anyway, because it's fast and you have a lot of control. Then again, I've been using it for 10 years, so I'm biased! :-) Depending on your experience, it may or may not be the right choice for you. Still, worth considering, IMHO.

Then again... SQL*Loader can go 'direct' and 'parallel', so it's performance may be very, very good if you can exploit it well. It just may not handle the parsing you require. Check the Oracle Utilities Manual for what it can, and cannot, do.

Steve Phelan.

Aseem H Raval wrote in message <351FD646.647B82D5_at_aur.alcatel.com>...
>Hi,
> I was wondering which of the following tools is better for parsing
>an ASCII file that has key words in it for loading Oracle:
>
> SQL *Loader
> PL/SQL
> Pro *C
>
>Thank You,
>Aseem H. Raval
>ravaah_at_aur.alcatel.com
>
Received on Tue Mar 31 1998 - 00:00:00 CEST