Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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.orgReceived on Wed Oct 17 2007 - 01:13:32 CDT
![]() |
![]() |