On 17 May 2004 17:40:28 -0700, ilaletin@usa.net (Igor Laletin) wrote:

....
>Shell (whichever one you use) substitutes '$database' with the value
>of its variable 'database'.
>
>> my question : How to rectify case 1 to ensure unix here document works ?
>
>Insert backslash before $.
....
And if you would have a lot of backslashing to do: you can prevent the
shell from interpreting the $ sign by putting single quotes around the
eof, thusly:

sqlplus -s /nolog <<'eof'

In that case no backslashing is needed.

Jaap.