Avatar of Wilder1626
Wilder1626
Flag for Canada 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.
Oracle DatabaseSQL

Avatar of undefined
Last Comment
Wilder1626

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Wilder1626

ASKER
Thanks for the idea. I will look at this option.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck