9 Replies Latest reply on May 13, 2011 5:34 AM by 860025

    How to extract blob from a table and save it as  a file?

      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

      Mohamed Hammed