Create .zip file using pl/sql

Do any of these threads help?

Creating zip files in pl/sql.

Zip 2+ GB file in plsql. Error when using as_zip

Re: Create Zip File

(huh, at first I didn't think this could be done - still trying to wrap my head around the method used in those thread Learn something new every day .. whee )

It should be noted that the LZ_COMPRESS used within the PL/SQL packages is not a high level of compression.  If you want that, you are best to create a Java wrapper for the Java zip functionality and use that instead.

Put that .csv / .dbf/ .xls.... file in a blob data type variable and then using utl_compress.lz_compress zip the file and place it in a Blob variable.

Rajanjai wrote:

 

Hi,

Thanks for looking into this. I'm already using as_zip package, my main issue is i need to use third party software to unzip the content . But I need to unzip it using windows default unzip software.

 

Thanks

Raj.

Anton's as_zip package should create zip files that can be unzipped with Windows as far as I recall.  However our own zip functionilty uses the Java zip method which creates zip files with better compression and those can certainly be unzipped with Windows.