Re: Appreciate Help with Query

From: <sybrandb_at_hccnet.nl>
Date: Tue, 16 Oct 2007 23:30:48 +0200
Message-ID: <5bbah35iajidmc7sgq56j36tbvq1soarth@4ax.com>

On Tue, 16 Oct 2007 11:24:49 -0700, Smitty <marksmithy69_at_hotmail.com> wrote:

>Hello everyone. I am pretty new to Oracle, so I'm hoping someone can
>help me. We have a table in our database, PHT, with 3
>columns...Photo_ID, Date and Photo. The Photo column is a BLOB which
>contains a jpg photo for each Photo ID.
>
>Is there a way that I can export or extract each jpg from the
>database, renaming it <Date>_<Photo_ID>.jpg, and saving each photo
>locally? Thanks very much for the help.

The package DBMS_LOB has functions or procedures to read and save files.

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Tue Oct 16 2007 - 16:30:48 CDT