Re: which server am I on?
From: Greg Jackson <gjackson_at_pier1.com>
Date: 1996/12/19
Message-ID: <59br17$avt_at_news0-alterdial.uu.net>#1/1
Date: 1996/12/19
Message-ID: <59br17$avt_at_news0-alterdial.uu.net>#1/1
[Quoted] In article <59bdan$ldf_at_svna0001.clipper.ssb.com> tahmossx_at_itd.ssb.com (Stephen A Tahmosh) wrote:
> One source of the data is: "select name from v$database;"
> column upper(VALUE) new_value _DB_NAME
> select upper(value) from v$parameter
> where upper(name) = 'DB_NAME';
> set SQLPROMPT '&_DB_NAME.> '
rather than querying the db, you could just add
HOST echo $ORACLE_SID
to the $ORACLE_HOME/sqlplus/admin/glogin.sql file.
greg jackson
gjackson_at_pier1.com
Received on Thu Dec 19 1996 - 00:00:00 CET