sqlplus和shell变量的交互

~/new_folder
$ str="2008-10-11"

~/new_folder
$ result=`sqlplus -s <set heading off
select to_date('$str','YYYY-MM-DD') from dual;
exit;
eof
`

~/new_folder
$ echo $result
11-10？ -08

$ result=`sqlplus -s <set heading off
select 1 from dual union select 2 from dual;
exit;
eof
`
~/new_folder
$ echo $result
1 2