CMD> sqlplus / as sysdba
SQL>
set serveroutput on;
SQL>
DECLARE
Result_Val VARCHAR2(100);
BEGIN
dbms_system.get_env('ORACLE_HOME', Result_Val);
dbms_output.put_line(Result_Val);
END;
/
SQL>
set serveroutput on;
SQL>
DECLARE
Result_Val VARCHAR2(100);
BEGIN
dbms_system.get_env('ORACLE_HOME', Result_Val);
dbms_output.put_line(Result_Val);
END;
/