Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: insert blob

Re: insert blob

From: Reiner Schnepel <RSchnepel_at_t-online.de>
Date: Sat, 6 Jan 2001 22:18:41 +0100
Message-ID: <93826v$c2t$06$1@news.t-online.com>

"Clinique" <clinique_at_gmx.net> schrieb im Newsbeitrag news:934980$kfv$1_at_nntp.hamburg.pop.de...
> Hi everybody,
> can anyone tell me if there is any chance to insert blobs via a simple
> insert statement? I only need some testdata...
>
> Susanne
>

Hi Susanne,

you should lookup the server documentation and search for the dbms_lob package. With 'dbms_lob.loadfromfile' you may load binary data (or whatever you want) into a blob.
There are some working examples which will meet your needs.

Reiner Received on Sat Jan 06 2001 - 15:18:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US