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.


Forgot to mention: Oracle 10g.

How you convert the.zip file into binary stream ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.