Re: sqlplus using Here document does not recognize v$ view ?

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Tue, 18 May 2004 22:01:30 +0200
Message-ID: <nsqka09pgdbo85lgeahm9bom0jsp7unu5g@4ax.com>

On 17 May 2004 17:40:28 -0700, ilaletin_at_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. Received on Tue May 18 2004 - 15:01:30 CDT