Redirect the Oracle query output to a file without using spool

Question

We would like to generate/redirect a sql query output to a Linux file. We do not have access to SQLPLUS on production systems. The script will go in Apps server code. Please help.

Regards

What are you using to run the query?

Joe
– Joe

2013-12-17 13:50:46 +00:00
Commented Dec 17, 2013 at 13:50 — Joe
– Joe, Commented Dec 17, 2013 at 13:50

Guntram Blohm · Accepted Answer · 2013-12-17 14:31:58Z

1

Well, you need some command that allows you to execute the query. If you don't have access to any such command, and can't copy sqlplus over (because it just needs too much of the client installed to work), the best idea i'd have is write a java program that either takes the query from the command line or has a few fixed queries built in, and that allows you to specify a file to write the output to. If you pack this program together with the thin client, you end up with one .jar file that doesn't rely on anything else - except a jre, which is more or less ubiquitous on today's server systems.

answered Dec 17, 2013 at 14:31

Guntram Blohm

9,8492 gold badges27 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Redirect the Oracle query output to a file without using spool

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related