# !/bin/ksh

##### Environment variables ######

export ORACLE_HOME="/opt/oracle/product/current"
export PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin:.
##################################


dbLoginStr="RAMSADM/welcome123@NPIDEV"

sqlplus $dbLoginStr  << EOT
select proj_id from ram_projects where rownum<2
/
EOT

exit;

> v=`sqlplus -s / <<EOF
> set echo off pages 0 feed off
> select * from dual
> /
> exit
> EOT
> `
> echo $v
X

 v=`sqlplus -s / <<EOF
 set echo off pages 0 feed off
 [B]select empno from emp[/B]
 /
 exit
 EOT
 `
 echo $v
X