Re: Oracle SID at run-time from SQL*Plus
From: Mark L. Zewe <Mark_at_Z.com>
Date: 1996/05/13
Message-ID: <4n7h6g$17g_at_inet-nntp-gw-1.us.oracle.com>#1/1
Date: 1996/05/13
Message-ID: <4n7h6g$17g_at_inet-nntp-gw-1.us.oracle.com>#1/1
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?
>--
>
>- -
>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 Mon May 13 1996 - 00:00:00 CEST