Shell Programming and Scripting

Hi All,

I have a shell script for ex-

#bin/ksh

sqlplus user/pass << EOF

select x from y;

EOF

my question is can I store the value of x in a variable in unix program so that i can user that value in shell script.....

additionally after catching the value i want to perform some activity and again pass it to databse for getting some data....

how can I do that...?

please help!!!!

You can spool the output using spool command

Thanks for you suggestion...


but is thr anyway other than that ......I dont want to spool the output in any file and use it afterwards.......

any suggestion guys?????//

Maybe this is what you wanted to do ?
print "select * from myTable" | sqlplus user/pass > output_file
or
print "select * from myTable" | sqlplus user/pass | some other commands

If not then you could try to use 'expect'.

Probably you could do something like
sqlplus user/pass >output_file <<EOF
select * from myTable
EOF
but this is not readable IMHO (and I am not sure which from the above would work).

A hint: ksh/sh/etc. don't have database support. Maybe PERL or something else would be a better choice?
In my company I am always seeing that some guys are using incorrect tools (especially some guys from India who knows only C# and tend to make everything in it - like to rewrite unix applications whar require adding extra communication/interface modules.... this is really sad).