Re: How to get the INSTANCE and SID name via SQL

From: Harris Ruan <hruan_at_ozemail.com.au>
Date: Sun, 10 Nov 2002 23:57:07 +1100
Message-ID: <Vwsz9.26335$Sr6.764098@ozemail.com.au>

If you have select catalog role then
select * from v$instance

"Lanying & Manfred Chen-Fischer" <manfis_at_chen-fischer.de> wrote in message news:aqlho6$df2$05$1_at_news.t-online.com...
> Hello my friends,
>
> I don't have any manuals...
>
> How to get the INSTANCE name and the SID name
> via SQL statement. Is there any SYSTEM table or view?
>
> Have a nice weekend
>
> Manfred
>
>
Received on Sun Nov 10 2002 - 06:57:07 CST

This message: [ Message body ]
Next message: Anton Buijs: "Re: How to get the INSTANCE and SID name via SQL"
Previous message: Lanying & Manfred Chen-Fischer: "How to get the INSTANCE and SID name via SQL"
In reply to: Lanying & Manfred Chen-Fischer: "How to get the INSTANCE and SID name via SQL"
Next in thread: Anton Buijs: "Re: How to get the INSTANCE and SID name via SQL"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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