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

From: Igor Racic <igor.racicC_at_freesurf.fr_no_C>
Date: Mon, 17 May 2004 21:38:44 +0200
Message-ID: <40a91483$0$22131$636a15ce@news.free.fr>

  Chyn,

   replace it with

                v\$database

  ( shell substitution thing )

                                   Igor

P.S. Huh, I've done something usefull today :-)

Ted Chyn wrote:
> 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
>
> /export/home/oracle/script > sqlplus system
>
> SQL*Plus: Release 9.2.0.3.0 - Production on Mon May 17 13:20:07 2004
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Enter password:
>
> Connected to:
> 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
>
> SQL> select name from v$database;
>
> NAME
> ---------
> EASDEV
Received on Mon May 17 2004 - 14:38:44 CDT