Scripting Interview Question:

How to connect to Oracle database, execute a script and assign its output to a shell variable?

Submitted by: Administrator

count=`sqlplus -s $configuser/$configpass@$ORACLE_SID <<END
set pagesize 0 feedback off verify off heading off echo off;
select max(cust_id) from cutomers
exit;
END`
echo $count
Submitted by: Administrator