Shell Programming and Scripting

#!/bin/bash
 
suc_num=`$PATH/sqlplus -s xx/yyy@service_name << !
set echo off
set feedback off
set heading off
set pagesize 0
set newpage 0
set wrap on
@success.sql
commit;
exit;
!`
 
echo $suc_num

2012-06-17 10 2 HLR_DUMMY 2012-06-17 11 1 HLR_DUMMY 2012-06-17 12 2 HLR_DUMMY 2012-06-17 15 1 HLR_DUMMY 2012-06-17 17 1 HLR_DUMMY 2012-06-17 00 102 aaa1 2012
-06-17 01 33 aaa1 2012-06-17 02 20 aaa1 2012-06-17 03 344 aaa1 2012-06-17 04 10 aaa1 2012-06-17 05 19 aaa1 2012-06-17 06 35 aaa1 2012-06-17 07 76 aaa1 2012-06-17 08 222 aaa1 2012-06-17 09 425 aaa1 2012-06-17 10 4211 aaa1 2012-06-17 11 552 aaa1 2012-06-17 12 994 aaa1 2012-06-17 13 1077 aaa1 2012-06-17 14 844 aaa1 2012-06-17 15 779 aaa1 2012-06-17 16 892 aaa1 2012-06-17 17 932 aaa1

echo "$suc_num"