Re: How to get the SID name ?
From: Guy Quesnel <gquesnel_at_magma.ca>
Date: Mon, 04 Jan 1999 04:14:01 GMT
Message-ID: <369040AA.45A4BEA0_at_magma.ca>
Date: Mon, 04 Jan 1999 04:14:01 GMT
Message-ID: <369040AA.45A4BEA0_at_magma.ca>
Hi,
Adrian wrote:
> Hi everybody,
In SQLPLUS, you can enter the following select statement;
"select name from sys.v$database;"
note that the v$database view belongs to the sys schema, and you may need
some dba privileges to view it.
>
> does enybody know, how to get the oracle SID-ALIAS name (alias for the
> instance from the tnsnames.ora file)
> from a PLSQL programm or from sqlplus ?
>
> Im working with Oracle Rel. 7.3.
>
> many thanks for your tip.
Received on Mon Jan 04 1999 - 05:14:01 CET