Re: current oracle_sid

In article <ae637542.0109251231.7a04b4a9_at_posting.google.com>, guxinhong_at_yahoo.com says...
>
>I have several database instances running on the local machine. When
>loggin into slq*plus, I could log into one instance without specifying
>Host_String. anybody know how to let Sql*plus to display the instance
>name in which it is currently connected.

see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:284615949318 http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:928829365838

...

--
Thomas Kyte (tkyte_at_us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp