Re: loading data from flat file into oracle table.

v.sorna_at_gmail.com wrote:
> I need to use OCI/DPL for architechtural reasona.
>
> also i'm not aware of external tables.my need is to copy data from flat
> file in client side to another remote database table.Can u please give
> some hints on the external table.
> it will be good if i'm able to do it with OCI OCCI dpl
>

External tables access data in a flat file as if it were a table in the database. Please look at the following documentation:

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm

Once you have defined the external table, then you can use any SQL statement to access the data in the flat file.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown