how to retrieve sql result to unix....

happyv · #1 (**permalink**) 02-07-2007

Hi,

i would like to retrieve seql result and write it into unix text file like "result.txt"

In unix, normally, I type "sql" and get into sql,then type "select....." to run and get the result....then copy and paste into result.txt

any possible way to write a script to run it automatically?

Thanks all!!!!

happyv · #2 (**permalink**) 02-07-2007

no one can help????????????????????

jim mcnamara · #3 (**permalink**) 02-07-2007

SEarch the forums. This question is asked almost every day.

Search on the word 'oracle'.

sumeet · #4 (**permalink**) 02-08-2007

I am using DB2

so once you connect to db2 run the following on unix prompt:

db2 -tvf query.file -z result.file

I dont remeber how to implement it on Oracle. But as far I can recollect:

sqlplus -s @username/password < $sql_file.sql > $sql_file.log

thanks
Sumeet

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
retrieve value from a file	satish@123	Shell Programming and Scripting	1	05-17-2008 07:40 AM
display the result of wc -l with words before and after the result	melanie_pfefer	UNIX for Dummies Questions & Answers	3	04-30-2008 07:33 AM
To retrieve Date/Time from Windows by unix/linux boxes	mpc8250	Shell Programming and Scripting	4	02-09-2008 12:31 AM
Outputting formatted Result log file from old 30000 lines result log<help required>	vikas.iet	Shell Programming and Scripting	5	12-02-2007 10:43 PM
how do we retrieve a line from a file in unix	lmadhuri	Shell Programming and Scripting	2	02-07-2007 08:07 AM

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