Re: Appreciate Help with Query

Smitty 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.

Depends on your version which you didn't think important to include.

Look at the DBMS_LOB and ULT_FILE demos in Morgan's Library at www.psoug.org.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org