Search Results

Thanks for the replies - sorry for the slow post, but this is what I actually ended up using.


fields=`sqlplus -s / <<END
set pagesize 0 feedback off verify off heading off echo off
select col1...

To all:

sorry - my question must not have been clearly stated - my problem is how do I assign the results of the sql select statement to variables that I can use in my shell script - i.e. connect...

Hello

I would like to perform a select from a oracle table and return those values to my shell script

For example:

site=head -1 $infile | cut -c1-15 | awk '{printf "s%", $0}
sqlplus -s...