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: How to load binaries with SQL?

RE: How to load binaries with SQL?

From: penpendisarapen <penpendisarapen_at_MailAndNews.com>
Date: Fri, 20 Apr 2001 14:36:03 -0400
Message-ID: <3AFFBD54@MailAndNews.com>

>===== Original Message From connor_mcdonald_at_yahoo.com =====
>penpendisarapen wrote:
>>
>> Help out a newbie.
>>
>> Images are stored in our product table under the picture field. Can I load
 a
>> .gif or .jpg file to the picture field with a SQL statement?
>>
>> TIA
>>
>> Victor
>
>This can be done with SQL Loader - see the examples in the case studies,
>or using the DBMS_LOB package...
>
>hth
>connor
>--

So, it can't be done with an SQL statement? I was actually hoping to write a Perl script using DBI to do batch loads.

Where can I find the case studies? Sorry for asking, I'm new to this and we're
in the process of hiring a DBA.

Thanks,

Victor Received on Fri Apr 20 2001 - 13:36:03 CDT

Original text of this message

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