Re: SQLLoader in an API?
From: GreyBeard <Fuzzy.GreyBeard_at_gmail.com>
Date: Thu, 24 Mar 2005 18:07:11 GMT
Message-Id: <pan.2005.03.24.19.08.39.718406_at_gmail.com>
Date: Thu, 24 Mar 2005 18:07:11 GMT
Message-Id: <pan.2005.03.24.19.08.39.718406_at_gmail.com>
On Wed, 23 Mar 2005 14:25:50 -0800, tachoknight_at_gmail.com wrote:
> Is there a SQLLoader-type API that I can call to do the same
> functionality from within my program?
Realizing this is not applicable, but perhaps this will add some fuel to the 'time to upgrade to a supported version' thought process....
Effective Oracle9i, you can use the 'External Table' capability as the SQL*Loader API.
In a nutshell, you can now create read-only tables that use the SQL*Loader syntax to map between the external file contents and the table's columns. Then you can use that table directly in SELECTs, JOINs and even MERGE statements.
/FGB Received on Thu Mar 24 2005 - 19:07:11 CET