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

tedchyn_at_yahoo.com (Ted Chyn) wrote in message news:<44a19320.0405171023.72ad9ac5_at_posting.google.com>...
> dear sir,
>
> why following sqlplus command using here document did not recognize
> the
> v$database(case 1). it worked in case 2 when login directly.
>
> my question : How to rectify case 1 to ensure unix here document works
> ?
>
>
> thanks ted
>
>
> =====
> 1. case 1
>
> SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 -
> 64bit Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.3.0 - Production
> /export/home/oracle/script > sqlplus -s /nolog <<eof
> > connect system/huni123_
> > select name from v$database;
> > exit
> > eof
> Connected.
> select name from v
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
> ======================
> 2. case 2

You need to escape the dollar sign, most likely by putting a backslash (\) before it. The shell is interpretting $database as an empty variable.

jg

--
@home.com is bogus.
Comment created.
Comment created.
Comment created.