Shell Programming and Scripting

entry_data_control=`sqlplus  ${sysuser}/${syspwd} << data_control
                      whenever sqlerror exit sql.sqlcode;
       whenever oserror exit failure;
       INSERT INTO LSHADMIN.STUDY_LEVEL_TABLE(SESSION_SID,SESSION_SERIAL_NO,FILE_NAME)
       select sid, serial# , '$i' FROM v\$session   WHERE audsid = userenv('sessionid');
       COMMIT;
       EXIT;
       data_control`

table="v\$session"
var=`sqlplus -s ${DB_LOGON}<< EOSQL
WHENEVER SQLERROR EXIT FAILURE;
WHENEVER OSERROR EXIT FAILURE;
set longchunksize 200000 long 200000 pages 0
set heading off
select sid from $table where rownum < 2;
exit
EOSQL`
echo $var

Makarand >./mak2.sh
525

timestamp=`date +"%Y%m%d%H%M%S"`
var=`sqlplus -s ${DB_LOGON}<< EOSQL
WHENEVER SQLERROR EXIT FAILURE;
WHENEVER OSERROR EXIT FAILURE;
set longchunksize 200000 long 200000 pages 0
set heading off
insert into c values(to_date($timestamp,'YYYYMMDDHHMISS'));
exit
EOSQL`
echo $var

 Makarand >./mak4.sh
1 row created.