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 extract blob from a table and save it as a file?

363269Mar 14 2007 — edited May 13 2011

Dear All

i have table employee (emp_id number , emp_name varchar2(60) emp_image blob)

1 - i want to extract the emp_image of every employee into a operating system folder c:\images
2 - the file name should be emp_id.gif or emp_id.jpg

How can i do that?

Thanks a lot in advance for your co-operation

Regards
Mohamed Hammed

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2023

Added on Mar 14 2007

#blob, #plsql, #xml

11 comments

83,841 views

1 mention