By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,541 Members | 1,525 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,541 IT Pros & Developers. It's quick & easy.

Redirecting the sql query output

P: 1
Hi,
How can i redirect the output of an sql select query to a tab delimited text file and to an excel file using perl script.

I use ,
system("sqlplus / \@$my_folder/qry.sql");
to call sqlplus.

What should be done next to catch the output in a text file and in an excel file with the column headers?

Kindly help.
Jun 23 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.