Re: which server am I on?

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 CST