954,561 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Extracting File From BLOB

Hello all,

I have a .zip file which is stored within a BLOB file. Using SQL Developer, how can I extract the .zip file from the BLOB in order to either open the file or store it on my local drive? I've never dealt with Zip files in BLOBS prior to this.


Thanks,
Clifton

kahaj
Junior Poster
193 posts since Sep 2005
Reputation Points: 10
Solved Threads: 0
 

Forgot to mention: Oracle 10g.

kahaj
Junior Poster
193 posts since Sep 2005
Reputation Points: 10
Solved Threads: 0
 

How you convert the.zip file into binary stream ?

debasisdas
Posting Genius
6,872 posts since Feb 2007
Reputation Points: 666
Solved Threads: 434
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You