Shell Programming and Scripting

var=`sqlplus username/password@database<<EOF
select date from table;
exit;
EOF`

function abc {
....
command 1
command 2
....
var=5
}

function main {
....
abc
date=$var           # I can directly use this variable here which was set in abc function
....
}

su - oracle<<EOC
export PATH=${PATH}:${ORACLE_HOME}/bin
id -a
exit
EOC

`sqlplus abc/xyz123@localdb<<EOS
select min(time) from tab_purg;
select max(time) from tab_purg;
exit
EOS`

set `sqlplus abc/xyz123@localdb<<EOS
select min(time)||"|"||max(time) from tab_purg;
exit;
EOS`

bothDates="$1"
first=`echo $bothDates|cut -d"\|" -f1`
second=`echo $bothDates|cut -d"\|" -f2`
echo "First=$first and Second=$second"