Re: Oracle SID at run-time from SQL*Plus

Mark_at_Z.com (Mark L. Zewe) writes:

>On Mon, 22 Apr 1996 07:15:00 -0700, Joern Moeller-Nielsen
><jmn_at_pip.dknet.sk> wrote:
 

>>Can anybody help with our litle problem.
>>
>>We have a couple of Unix-machines, and we would like to
>>see Oracle SID from within SQL*Plus.
>>
>>Is this posible?

Yes sure is - Try to select KSQDNGDN from sys.x$ksndn.

>>--
>>
>>- -
>>Joern Moeller-Nielsen, jmn_at_pip.dknet.dk
>>Dansk Industri, DK-1787 Copenhagen
>>Tel: +45 33 77 30 52; Fax +45 33 77 33 00

>Not sure about the unix platform but from the desktop platform their
>is a table viewable as user sys called v$database. This includes the
>oracle SID.
 

>Mark
Received on Wed May 15 1996 - 00:00:00 CEST