Skip to Main Content
  • Questions
  • Zip a .csv file present at DB directory using PL/SQL

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Amar.

Asked: May 07, 2021 - 4:20 am UTC

Last updated: May 07, 2021 - 4:22 am UTC

Version: 19c

Viewed 100+ times

You Asked

We have a requirement where we are generating .csv file from DB and placed it to a DB directory. We want to zip these .csv files so that size can be optimised. Could you please suggest a way to achieve it by using PL/SQL.

and we said...

Check out Anton's zip package - its pretty cool

https://github.com/yallie/as_zip

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library