Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> RE: How to load binaries with SQL?
>===== 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
![]() |
![]() |