Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Redirecting sql select query result to txt file
Top Forums Shell Programming and Scripting Redirecting sql select query result to txt file Post 302208501 by dolphin123 on Tuesday 24th of June 2008 04:21:47 AM
Old 06-24-2008
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 data was just thrown into the text file. There was no format.

How should i include code in sql file (containg the select query) so that the output to the text file is formatted neately with tab.

Kindly 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 , 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... (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

LEARN ABOUT DEBIAN

template::dbi

Template::DBI(3pm)					User Contributed Perl Documentation					Template::DBI(3pm)

NAME

       Template::DBI - DBI plugin for the Template Toolkit

SYNOPSIS

	   $ perldoc Template::Plugin::DBI

DESCRIPTION

       The Template-DBI distribution contains the DBI plugin for the Template Toolkit.	At some point in the future it is likely to contain other
       DBI-related plugins and extension modules for the Template Toolkit.

       The DBI plugin was distributed as part of the Template Toolkit until version 2.15 released in May 2006.	At this time it was extracted into
       this separate Template-DBI distribution.

       See the documentation for Template::Plugin::DBI for further details on using the DBI plugin.

AUTHORS

       The DBI plugin was originally written by Simon A Matthews, and distributed as a separate module.  It was integrated into the Template
       Toolkit distribution for version 2.00 and included contributions from Andy Wardley, Craig Barratt, Dave Hodgkinson and Rafael Kitover.
       Andy Wardley extracted it back into a separate distribution in May 2006.  After that, in 2010 Jens Rehsack maintains this distribution.

COPYRIGHT

	 Copyright (C) 1999-2006 Simon Matthews, Andy Wardley.	All Rights Reserved
	 Copyright (C) 2010 Jens Rehsack.  All Rights Reserved

       This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

SEE ALSO

       Template, Template::Plugins, Template::Plugin::DBI, DBI, Tie::DBI

perl v5.10.1							    2011-02-05							Template::DBI(3pm)
All times are GMT -4. The time now is 10:05 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy