Shell Programming and Scripting

 
sqlplus -silent $user/$pass@dbname <<END
select col1,
         col2,
         col3
from table_name where col4=$1;
exit;
END

 
cat set_DB_var.ksh
 
ksh get_DB_var.ksh 
echo $col1
echo $col2
echo $col3

 
get_DB_var.ksh 
---------------
sqlplus -silent $user/$pass@dbname <<END > var_file.txt
select col1,
         col2,
         col3
from table_name where col4=$1;
exit;
END
 
set_DB_var.ksh
---------------
while read var_file
do
echo $col1
echo $col2
echo $col3
done

from table_name where col4=$1;

col4="some_value"

. get_DB_var.ksh
echo $col4

RESULT=`sqlplus -silent $user/$pass@dbname <<END
select col1,
         col2,
         col3
from table_name where col4=$1;
exit;
END`

for COL in $RESULT; do
     echo $COL #do something with them here
done

from table_name where col4=$1;

./get_DB_var.ksh some_file_info_var

select col1,
         col2,
         col3
from table_name where col4=some_file_info_var;

select a,
         b,
         c
from table_name where col4=$1;

echo $col1 is a
echo $col2 is b
echo $col3 is c
echo $col4 is some_file_info_var # you are already having this.

sqlplus -s user/pass@DB <<END > result_file
set pagesize 0 linesize 10000 feedback off verify off heading off echo off
select
'EMP='||EMP||','||
'DEPT='||DEPT||','||
'JOB_NAME='||JOB_NAME
from employees where emp_id=$1;
exit;
END

EMP=1,DEPT=IT,JOB_NAME=SOFTWARE ENGINEER

EMP=1
DEPT=IT
JOB_NAME=SOFTWARE ENGINEER

sqlplus -s user/pass@DB <<END > result_file
set pagesize 0 linesize 10000 feedback off verify off heading off echo off
select
'EMP='||EMP||\n||
'DEPT='||DEPT||\n||
'JOB_NAME='||JOB_NAME
from employees where emp_id=$1;
exit;
END