Tag: DBMS_SYSTEM

QUERYING THE ORACLE_HOME PATH FROM A DATABASE

  REQUEST I want to get the ORACLE_HOME path by querying the database.   RELATED GETTING THE VALUE OF AN ENVIRONMENT VARIABLE THROGHT PL/SQL BLOCK   SOLUTION   DBMS_SYSTEM COL ORACLE_HOME FOR A30 VARIABLE ORACLE_HOME VARCHAR2(100); EXEC DBMS_SYSTEM.GET_ENV(‘ORACLE_HOME’,:ORACLE_HOME); PRINT ORACLE_HOME ORACLE_HOME —————————— /oracle/product/12.2.0.1   DBA_LIBRARIES…