Re: System Variable in PL/SQL
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.