Executing Sql Query Using Shell Script

ragha81 · #1 (**permalink**) 07-27-2006

HI ALL
i have a requirement like this. i have to write a shell script to run a sql query. DB is oracle. once the query is run, the results of the query has to be published in a data file. can you please advice me how to go about it. i am absolutely new to shell scripts and this is a part of my job.

tmarikle · #2 (**permalink**) 07-27-2006

This question is answered several times a week; please search the forums.

ragha81 · #3 (**permalink**) 07-27-2006

thanks for the reply, i am new to this group and I will look for the posts

tmarikle · #4 (**permalink**) 07-27-2006

This post may get you started.

chittari · #5 (**permalink**) 07-28-2006

try this

DATA=`echo "SET HEADING OFF;\n SET FEED OFF;\n select <whatever query you want here > ;\n exit\n"|sqlplus -s /`

echo $DATA > <whatver file you want>

ragha81 · #6 (**permalink**) 07-28-2006

hi

i tried your query. when i execute that i am getting an error like this "SQL plus cant be found" is there a way not to mention the user name and pwd in the script. thanks

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
C Shell Script query	bpupdown	Shell Programming and Scripting	1	05-13-2008 07:38 PM
Need Unix script for executing oracle query	ravi gongati	Shell Programming and Scripting	14	03-24-2008 05:53 AM
Script executing sql query	kingluke	Shell Programming and Scripting	2	01-23-2008 01:57 PM
executing a SQL query in shell script	lijju.mathew	Shell Programming and Scripting	1	05-17-2007 11:29 AM
Executing a SQL query from a shell script	98_1LE	UNIX for Dummies Questions & Answers	3	03-23-2002 03:29 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