Re: How to load binaries with SQL?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 20 Apr 2001 19:04:51 +0800
Message-ID: <3AE017D3.577C@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

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

Received on Fri Apr 20 2001 - 06:04:51 CDT