9 Replies Latest reply: May 13, 2011 12:34 AM by 860025 RSS

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

    363269
      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