Wilder1626
asked on
Oracle batch extract into xlsx format
Hi all
Each week, i'm extracting into xlsx format about 20 custom queries.
Manually, it takes a lot of time. I only have a limited access to the tables and i'm also using Oracle SQL Developper version 4.0.3.16.
I have all my custom queries under the Reports / All Reports and under User Defined Reports.
How can i pull all the queries so that it automatically extract into xlsx format in a folder?
Is this even possible?
Thanks for your help.
Each week, i'm extracting into xlsx format about 20 custom queries.
Manually, it takes a lot of time. I only have a limited access to the tables and i'm also using Oracle SQL Developper version 4.0.3.16.
I have all my custom queries under the Reports / All Reports and under User Defined Reports.
How can i pull all the queries so that it automatically extract into xlsx format in a folder?
Is this even possible?
Thanks for your help.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER