SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to export a BLOB content to a file

Mark1970Jul 4 2012 — edited Jul 4 2012

Without using tools like Toad or Sql Developer, I'd like to know how it's possible to export a BLOB content to a file.
I mean, let's suppose I have the table
MYTABLE (ID_KEY NUMBER, PDF_CONTENT BLOB) where the BLOB column contents a PDF,
how can I write a procedure (pl/sql or sql, ...) for exporting the BLOB content on file (UNIX or Windows)?
Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 1 2012

Added on Jul 4 2012

4 comments

8,036 views