Re: current oracle_sid
From: Robert Meerwaldt / Heleen van Beekhuizen <h.beekhuizen1NOSPAM_at_chello.nl>
Date: Wed, 26 Sep 2001 16:57:12 GMT
Message-ID: <INns7.51994$d61.721167_at_amsnews03.chello.com>
Date: Wed, 26 Sep 2001 16:57:12 GMT
Message-ID: <INns7.51994$d61.721167_at_amsnews03.chello.com>
To check which database I am currently connect to in SQL*Plus I always use:
select * from v$database;
good luck,
Robert
"simon gu" <guxinhong_at_yahoo.com> schreef in bericht
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 - 18:57:12 CEST