Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to get the oracle SID name ?

Re: How to get the oracle SID name ?

From: David Jonsson <davidjonsson_at_hotmail.com>
Date: Mon, 4 Jan 1999 21:13:00 +0100
Message-ID: <76r7f2$so7$1@romeo.dax.net>


hi! you can use
select * from global_name;

that one have worked fine for me :-)

Adrian wrote in message <368f8c53.0_at_news.swol.de>...
>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.
>
>my email is: adrian.moor_at_swol.de
>
>many thanks for your tip.
>
>
>
>
Received on Mon Jan 04 1999 - 14:13:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US