Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Mohammed.

Asked: January 18, 2018 - 1:45 pm UTC

Last updated: January 18, 2018 - 2:06 pm UTC

Version: 12

Viewed 1000+ times

You Asked

Hello MR.TOM
please i have answer

Reading image file to custom table and export the image into a new file.

Let's say we have a file called 'horse.jpg' and upload it to a table.

After that you wat to export it to a new file horse1.jpg

Open the file after expoting it to see the same image without any problems

many thanks Mr.TOM

and Chris said...

Presumably you're storing this in a BLOB. If so, you can use UTL_file to write blobs to the database file system:

https://oracle-base.com/articles/9i/export-blob-9i

Alternatively, you can view the image in SQL Developer:

https://www.thatjeffsmith.com/archive/2012/01/sql-developer-quick-tip-blobs-and-images/

And download and save it from there.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Mohammad Borghol, January 19, 2018 - 3:11 pm UTC


more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database