Shell Programming and Scripting

$ sqlplus.exe "/ as sysdba"

SQL*Plus: Release 9.2.0.1.0 [...]

SQL> select value from v$parameter where name='user_dump_dest';

VALUE
-------------------------------------------------------------
C:\oracle\admin\TUA7\udump

$ ret=`sqlplus.exe -s "/ as sysdba" <<_eof_
set pagesize 0 linesize 200 feedback off
select value from v\\\$parameter where name='user_dump_dest';
_eof_`

$ echo $ret
C:\oracledmin\TUA7\udump$

/home/oracle/tmp > cat Test1
ret=`sqlplus -s / as sysdba <<_eof_
  set pagesize 0 linesize 200 feedback off
  select st from s\\\$test;
_eof_`

echo $ret


/home/oracle/tmp > ./Test1
c:\oracle\admin\blah1\blah2
/home/oracle/tmp >

$ ret="$(sqlplus.exe -s "/ as sysdba" <<"_eof_"
set pagesize 0 linesize 200 feedback off
select value from v$parameter where name='user_dump_dest';
_eof_)"

$ echo "$ret"

echo "$ret"

print -r "$ret"

$ print -r "$ret"
C:\oracle\admin\TUA7\udump

$ print -r "$ret" | sed -e "s:^:#:g" | sed -e "s:$:#:g"
#C:\oracle\admin\TUA7\udump