Re: System Variable in PL/SQL

From: Marc de Brouwer <mbrouwer_at_nl.oracle.com>
Date: 1995/08/13
Message-ID: <40lp5r$l88_at_nlsu110.nl.oracle.com>#1/1


Jeff Hansen (jhanse1_at_abacus.tis.tandy.com) wrote:
: Howdy All,
 

: I would like to write some PL/SQL scripts that could access some system type
: variables such as :
 

: system name / node name / machine name
: SID / instance
:
 

: These type of variables would be useful on PL/SQL reports because of many
: different systems and instances.
 

: I am operating on Unix systems.
 

: Thanks,

: Jeff L. Hansen
: Tandy Corporation
: jeff.hansen_at_tandy.com

Jeff,

There aren't any system variables in PL/SQL (but in forms you can reference forms system variables).
The information you seem to need however can be retrieved from several Server dictionary views, such as sys.V$session. Check out appendix B of the Oracle7 Server Administrator's Guide.

Hope this helps you some.

Greets,
Marc.

  • These are MY OWN opinions, not Oracle's.
Received on Sun Aug 13 1995 - 00:00:00 CEST

Original text of this message