Re: How to get the SID name ?

In SQLPLUS, you can enter select * from global_name (or global_names, I can never remember if there is an "s" at the end).

• steve

> Hi,
> 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.
>
> Adrian wrote:
>
> > Hi everybody,
> >
> > 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 Tue Jan 05 1999 - 03:05:19 CET