Re: System Variable in PL/SQL

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.