Search notes:

Oracle: Read the value of an environment variable with DBMS_SYSTEM.GET_ENV

dbms_system.get_env allows to read the value of an environment variables:

declare
   temp varchar2(1234);
begin
   sys.dbms_system.get_env('TEMP', temp);
   dbms_output.put_line(temp);
end;
/

See also