Format Of SELECT Statement (Within A Script) For A Table Name That Contains A "$"
This i no problem when calling from within SQLPLUS, but when it is called from a UNIX script, the "$" is intrepreted as a special character.
Here is the script I am trying to write...
#!/bin/ksh
set -o xtrace
USERPW='system/apr05apr'
FirstLog=`sqlplus -s 2>&1 << ENDSQL
${USERPW}
select sequence# from v\$log where status='CURRENT';
ENDSQL`
echo 'First Archive Log - ${FirstLog}'
exit
Normally assums I would use an escape character as above... but I just can not seem to get the correct foramt ...