Re: current oracle_sid

From: Richard Armstrong <richard.armstrong_at_juno.demon.co.uk>
Date: Wed, 26 Sep 2001 01:07:20 +0100
Message-ID: <1001462930.17022.0.nnrp-13.9e9809ca_at_news.demon.co.uk>


There are instance name and database name parameters in the table v$parameter. Would these be any use to you?

"simon gu" <guxinhong_at_yahoo.com> wrote in message news:ae637542.0109251231.7a04b4a9_at_posting.google.com...
> 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.
Received on Wed Sep 26 2001 - 02:07:20 CEST

Original text of this message