GETTING THE VALUE OF AN ENVIRONMENT VARIABLE THROGHT PL/SQL BLOCK

 
REQUEST

 
SOLUTION

First, define a variable

oracle@dbpilot.net: export MYVAR="My Variable"
oracle@dbpilot.net: echo $MYVAR
My Variable

A value of any variable can be retrieved through DBMS_SYSTEM.GET_ENV procedure

COL OS_VAR FOR A30
VARIABLE OS_VAR VARCHAR2(50);
EXEC DBMS_SYSTEM.GET_ENV('MYVAR',:OS_VAR);

SQL> PRINT OS_VAR;

OS_VAR
------------------------------
My Variable