Re: how to store a txt file in oracle?

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Tue, 18 Jan 2000 18:10:14 +0200
Message-ID: <38849066.7487CB4D@0800-einwahl.de>

Hi lkw,

it depends from where to where you want to transfer. Some ideas for Oracle 8.1.5:

file is on db server: work with BLOBs or CLOBs or NCLOBs and BFILEs (works nice and fast). See the examples in the online doc.
file is on client: sqlload into BLOB/CLOB/NCLOB. See again the examples in the docs for this.

Martin

lkw wrote:
>
> hi all,
>
> izzit possible to store a txt file into a particular column of a table in
> oracle?
> if yes, how to do the insert? and how about select back?
>
> thanks...yr help would be greatly appreciated!!
>
> lkw.
Received on Tue Jan 18 2000 - 10:10:14 CST