Redirecting sql select query result to txt file

dolphin123 · #1 (**permalink**) 06-23-2008

Hi ,
I just found you while surfing for the string
'Redirecting sql select query output from within a shell script to txt file/excel file'

Could you find time sending me the code for the above question?
It'll be great help for me.

I have a perl file that calls the sql file (qry.sql). The sql file have my select query in it.

In the perl file i call sqlplus to execute the select statement.
system("sqlplus / \@$SALES_INCENT/qry.sql");

But i'm confused what should be done next to reach my target of sending the output to a tab delimited text and / or excel file.

Please help.

Yogesh Sawant · #2 (**permalink**) 06-23-2008

how about using DBI and one of the DBDs to do a database transaction or run a sql query?
for example, if you are using Oracle, you'd need DBI and DBD::Oracle

module Spreadsheet::WriteExcel is a good one to create an Excel file

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Reading from a file and passing the value to a select query	er_ashu	UNIX for Dummies Questions & Answers	1	06-19-2008 03:58 AM
how to convert the result of the select query to comma seperated data - urgent pls	Hemamalini	Shell Programming and Scripting	1	06-16-2008 04:27 AM
Need Help (Select query)	topgear1000cc	Shell Programming and Scripting	5	02-12-2008 07:22 AM
formatting the sql select result	kotasateesh	Shell Programming and Scripting	2	08-28-2007 02:31 AM
Select a portion of file based on query	vanand420	Shell Programming and Scripting	14	10-31-2006 04:48 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by