CODE EXAMPLE FOR SQL

oracle_home sqlplus

select SYS_CONTEXT ('USERENV','ORACLE_HOME') from dual;