Query Automation, pls help

[Actuary_DBA]

I have PL/SQL Developer

I am trying to run about 30 queries and have the results exported to my hard-drive in a csv format. Is there any way to do this in either PL/SQL Dev or another program? Thanks

 

[Marco Kalter]

This is not possible in PL/SQL Developer. Our Query Reporter freeware utility can do this though. It requires that it is launched 30 times for these queries, with corresponding command-line parameters to save as CSV.

 

[Actuary_DBA]

Thanks, where can I get this? Can a bacth file be used to run launch the 30 sessions within the Query Reporter?

 

[Actuary_DBA]

Hi Marco Kalter,
Can the tool you spoke of save in a csv format? I am only seeing documentation that speaks of html.

 

[Marco Kalter]

It can indeed save (export) the result set in CSV format. Interactively you can do so by pressing the export button.

On the command-line you can specify the CSV parameter. For example:

queryreporter userid=scott/tiger@chicago exec=C:\Temp\report01.rep csv=C:\temp\report01.csv hide