Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Querying environment variables

Re: Querying environment variables

From: stever <steve.rainbird_at_mssint.com>
Date: 4 Dec 2006 05:40:54 -0800
Message-ID: <1165239654.317628.43510@73g2000cwn.googlegroups.com>


Thanks to Laurnet in the oracle forums I have the following solution

SQL> var f varchar2(40)
SQL> set autop on
SQL> exec dbms_system.get_env('PWD',:f)

Steve

On Dec 4, 12:40 pm, "stever" <steve.rainb..._at_mssint.com> wrote:
> Is it possible from inside a pl/sql block to query the environment
> variables that were set when the database was started?
>
> I don' t beleive I am the only person who has asked this, but cannot
> find the answer anywhere.
>
> TIA
>
> Steve
Received on Mon Dec 04 2006 - 07:40:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US