Get SQL query result to file in putty


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Get SQL query result to file in putty
# 1  
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.

Code:
 uname -a
SunOS XXX 5.8 Generic_117350-58 sun4u sparc SUNW,Sun-Fire-480R

Please suggest.
# 2  
Through what database you run your SQL Query ?.

In mySQL:
Code:
SELECT * FROM TABLE INTO OUTFILE '/your_location/filename';

In postgresql:

Code:
\o /your_location/filename/
SELECT * FROM TABLE;
\o


Last edited by Gautham; 06-11-2014 at 09:15 AM.. Reason: updated code
# 3  
try
Code:
sqlplus -s ${DB_LOGON} <<EOSQL
WHENEVER SQLERROR EXIT FAILURE;
WHENEVER OSERROR EXIT FAILURE;
spool output.file
select * from dual;
spool off
EOSQL

# 4  
Thanks for the quick answers.

but how we can do it for isql ?
# 5  
iirc, isql supports -o <output file>.
# 6  
Quote:
Originally Posted by pamu
How to Get SQL query result to file in putty?
At the risk of being pedantic, but to clarify what may be some fuzzy thinking, putty is just a terminal program - one of several that do exactly the same thing. All it does is take keystrokes from your keyboard and send them to a remote system to be processed, then receive and display whatever character strings the remote system produces in response. It has nothing in particular to do with getting SQL query result into a file.

As others are pointing out, how to get the query result into a file is a function of whatever program is actually processing your query - the client program to whatever your rdbms system is.

Also, be aware that however that file is created (like oracle's sqlplus SPOOL command) it will be created on that remote system. If you need to get the file from the remote system to your desktop where you are running putty, that is a different question.

Please clarify your exact requirement.
This User Gave Thanks to edstevens For This Post:
# 7  
Quote:
Originally Posted by edstevens
At the risk of being pedantic, but to clarify what may be some fuzzy thinking, putty is just a terminal program - one of several that do exactly the same thing. All it does is take keystrokes from your keyboard and send them to a remote system to be processed, then receive and display whatever character strings the remote system produces in response. It has nothing in particular to do with getting SQL query result into a file.

As others are pointing out, how to get the query result into a file is a function of whatever program is actually processing your query - the client program to whatever your rdbms system is.

Also, be aware that however that file is created (like oracle's sqlplus SPOOL command) it will be created on that remote system. If you need to get the file from the remote system to your desktop where you are running putty, that is a different question.

Please clarify your exact requirement.
Yes agreed, But many times we don't have many options.
I have only putty to access this DB and I want to validate there itself. You should understand that there are many things which are not in our hand in actual world.(basically in any bank)
Then we have to try within our boundaries itself. Don't have any options Smilie.
I have tried all the inputs given in this post but nothing is working for me.
Please suggest how I can achieve this.

Thanks,
Pamu
Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #333
Difficulty: Easy
Linux was first developed as an alternative to Windows XP.
True or False?

10 More Discussions You Might Find Interesting

1. Programming

Oracle simple SQL query result in: ORA-08103: object no longer exists

Dear community, please help with a query on Oracle. I'm using SQLPlus (but with SQLDeveloper is the same) to accamplish a sinple query like: select count(*) from ARCHIT_D_TB where (TYP_ID=22 OR TYP_ID=23) and SUB_TM like '%SEP%' and CONS=1234This is a very simple query that works perfect until... (5 Replies)
Discussion started by: Lord Spectre
5 Replies

2. Shell Programming and Scripting

Read input file and used it to SQL query

Hi All, Seeking for your assistance to read each line $1 and $2 of input file and used it to query. Ex. file1.txt(number range) 9064500000 9064599999 9064600000 9064699999 9064700000 9064799999 Database name: ranges_log a_no message 9064500001 test 9064700000 ... (7 Replies)
Discussion started by: znesotomayor
7 Replies

3. 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

4. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies

5. UNIX for Dummies Questions & Answers

How do I use SQL to query based off file data?

This is basically what I want to do: I have a file that contains single lines of IDs. I want to query the oracle database using these IDs to get a count of which ones match a certain condition. the basic idea is: cat myfile | while read id do $id in select count(PC.ptcpnt_id) from... (4 Replies)
Discussion started by: whoknows
4 Replies

6. 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

7. 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

8. 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

9. Shell Programming and Scripting

any possible to run sql result and output to file

Hi, I search all post...and no soluation about..if i would like to run a sql statement and output the result to txt file. for example, i usually run "sql" to logon the database and run select statement. Then I need to copy the output into the result.txt. Can I run the script to do this... (7 Replies)
Discussion started by: happyv
7 Replies

10. Shell Programming and Scripting

unloading sql query to file

In unload to "/usr/home/data.012202" I wish to use a date variable as in unload to "/usr/home/data.`date`" for the file is that possible in a query to do, or will i need to add a mv command after the query to do it. I tried backquotes, , and () on `date` but didn't seem to work Thanks... (2 Replies)
Discussion started by: Link_02
2 Replies

Featured Tech Videos