Sponsored Content
Top Forums Shell Programming and Scripting Redirecting sql select query result to txt file Post 302208148 by dolphin123 on Monday 23rd of June 2008 05:46:14 AM
Old 06-23-2008
Redirecting sql select query result to txt file

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.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

formatting the sql select result

Hi, I have about 12 columns and 15 rows to be retrived from sybase isql command through unix. But when i output the sql into a file and see it, the formatting is going for a toss. can someone please suggest how can i get the result correctly in the output file ? Thanks, Sateesh (2 Replies)
Discussion started by: kotasateesh
2 Replies

2. Shell Programming and Scripting

how to convert the result of the select query to comma seperated data - urgent pls

how to convert the result of the select query to comma seperated data and put in a .csv file using korn shell. Pls help me as its very urgent. Thanks, Hema. (1 Reply)
Discussion started by: Hemamalini
1 Replies

3. Shell Programming and Scripting

Redirecting sql select query result to txt file

Hi Yogesh, Lucky that i caught you online. Yeah i read about DBI and the WriteExcel module. But the server is not supporting these modules. It said..."Cannot locate DBI"..."Cannot locate Spreadsheet::WriteExcel" I tried creating a simple text file to get the query output, but the... (1 Reply)
Discussion started by: dolphin123
1 Replies

4. Shell Programming and Scripting

In a csh script, can I set a variable to the result of an SQLPLUS select query?

Can someone tell me why I'm getting error when I try to run this? #!/bin/csh -f source ~/.cshrc # set SQLPLUS = ${ORACLE_HOME}/bin/sqlplus # set count=`$SQLPLUS -s ${DB_LOGIN} << END select count(1) from put_groups where group_name='PC' and description='EOD_EVENT' and serial_number=1;... (7 Replies)
Discussion started by: gregrobinsonhd
7 Replies

5. Shell Programming and Scripting

How to Format the result driven from a SQL Query

Hi All, I want to format the result driven from the query into neat format. For example pls find the below code, #! /bin/sh result=' sqlplus -s uname/passwrd@DBname select no,name,address,ph_no, passport_no,salary,designation from emp_table where salary>1000; exit EOF' ... (8 Replies)
Discussion started by: little_wonder
8 Replies

6. Shell Programming and Scripting

redirecting sql query output to a file

Hi, I am executing sql files in my unix shell script. Now i want to find whether its a success or a failure record and redirect the success or failure to the respective files. meaning. success records to success.log file failure record to failure.log file. As of now i am doing like... (1 Reply)
Discussion started by: sailaja_80
1 Replies

7. Shell Programming and Scripting

redirecting oracle sqlplus select query into file

So, I would like to run differen select queries on multiple databases.. I made a script wich I thought to be called something like.. ./script.sh sql_file_name out.log or to enter select statement in a command line.. (aix) and I did created some shell script wich is not working.. it... (6 Replies)
Discussion started by: bongo
6 Replies

8. UNIX for Advanced & Expert Users

Output the SQL Query result to a File

Hello Guys, This message is somewhat relates with last thread. But I need to re-write thing. I start over a little. I am stuck now and need your help. Here is my script- #! /bin/ksh export ORACLE_HOME=/opt/oracle/app/oracle/product/9.2 /opt/oracle/app/oracle/product/9.2/bin/sqlplus -s... (5 Replies)
Discussion started by: thepurple
5 Replies

9. Shell Programming and Scripting

How to store the sql query output into txt file?

Hi I want ot save SQL query result in one txt file. for that i have written one code line sqlplus -s $dbstring @/usr/local/bin/sched/nightly_Cronjob/exec_123.sql >> /usr/local/bin/sched/nightly_Cronjob/result.txt but it is not working . database : Oracle so please advice me how can i... (7 Replies)
Discussion started by: Himanshu_soni
7 Replies

10. Shell Programming and Scripting

Get SQL query result to file in putty

How to Get SQL query result to file in putty? I have one SQL query and I want that query output to be redirected to the file. uname -a SunOS XXX 5.8 Generic_117350-58 sun4u sparc SUNW,Sun-Fire-480R Please suggest. (7 Replies)
Discussion started by: pamu
7 Replies
SWAC-GET(1)						      General Commands Manual						       SWAC-GET(1)

NAME
swac-get - audio collections of words (SWAC) manager SYNOPSIS
swac-get [-t] [clear] [update] | [upgrade] | [select <url|packid>] | [deselect <url|packid>] | [list] | [list-sources] | [list-available] | [sql <query>] | [--help] | [--version] DESCRIPTION
Swac-get is a simple command line program which allows to download and install audio collections of words (SWAC) in a SQLite3 database. Audio collections can be imported from the hard drive or directly from the Internet using the HTTP protocol. Swac-get is designed to be used with swac-explore, a GTK+ interface which allows the browsing of the created SQLite3 database. An important set of free audio collec- tions of words (SWAC) is available at: http://swac-collections.org/ For more information, please, visit the Shtooka Project homepage at: http://shtooka.net/ . COMMANDS
clear clear database deselect <url|packid> delete records of the package <url|packid> from the database list list installed packages list-available list available packages list-sources list source repositories sql <query> execute a sql query in the database select <url|packid> insert records of the package <url|packid> in the database ex: swac-get select file:///home/<my directory>/ swac-get select http://packs.shtooka.net/<my package>/ogg/ swac-get select fra-balm-voc select source-delete <url> delete <url> from the repositories list source-deselect <url> deselect <url> from the repositories list source-select <url> add <url> to the repositories list ex: swac-get source-select http://packs.shtooka.net/ swac-get source-select file:///home/<my directory>/ update update the list of available packages upgrade upgrade installed packages OPTIONS
-t, --target <path> set the SQLite3 database path (default path is ~/.swac/swac.db) -v, --version print version information and exit -h, --help print this help and exit EXAMPLES
swac-get source-select http://packs.shtooka.net/ swac-get update swac-get select chi-balm-hsk1 swac-get select fra-balm-voc BUGS
swac-get doesn't care about the version number for the upgrade command. AUTHOR
swac-get and this manual page were written by Nicolas Vion <nico@picapo.net>. mai 25, 2008 SWAC-GET(1)
All times are GMT -4. The time now is 11:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy