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

From: Ken Atkins <katkins_at_iccom.com>
Date: 1996/05/15
Message-ID: <01bb41f9.b424e6c0$0605eecd_at_katkins.iccom.com>#1/1

I use the following SQL:

SELECT value

   FROM v$parameter
WHERE upper(name) = 'DB_NAME';

---

Ken Atkins - Oracle Programmer/Analyst (katkins_at_iccom.com)

In an effort to contribute some content to the Web I have created an 'Oracle Hint of the Week' site:

   http://www.iccom.com/usrwww/katkins/orahint.htm

Check it out!

---

On Monday, May 13, 1996, Mark L. Zewe wrote...
> 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 Wed May 15 1996 - 00:00:00 CEST