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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Getting Unix environment variable from SQL or PL/SQL

Re: Getting Unix environment variable from SQL or PL/SQL

From: Mohammad Farid <mfarid_at_bio.ri.ccf.org>
Date: Mon, 01 Feb 1999 14:55:31 -0500
Message-ID: <36B606B3.88E75328@bio.ri.ccf.org> 






You can user 'host' or '!' at the sql prompt.
 e.g.


SQL> host env


   or


SQL> host echo $ORACLE_SID



Maverick wrote:



> Hi


>


> Does anyone know how to get Unix environment variables from SQL


> or PL/SQL.


>


> Thank you in advance.


>


> Please send all comments to:   mav_at_ghg.net



Received on Mon Feb 01 1999 - 13:55:31 CST












Original text of this message













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