URL https://te31.com/rgr/view.php?id=pcclub&no=20918 모바일 화면

select 'oracle_home' as name, substr(file_spec,1,instr(file_spec,'/',-1,2)-1) as value
from dba_libraries
where library_name = 'DBMS_SUMADV_LIB'
union all
select 'oracle_home' as name, substr(file_spec,1,instr(file_spec,'\',-1,2)-1) as value
from dba_libraries
where library_name = 'DBMS_SUMADV_LIB'

이런 덜떨어진 방법 말고

set serveroutput on;
var ORACLE_HOME varchar2(255);
execute dbms_system.get_env('ORACLE_HOME',:ORACLE_HOME);
print ORACLE_HOME;

이렇게 PL/SQL 쓰는 방법 말고
그냥 깔끔하게 ORACLE_HOME만 뽑아낼 방법이
지저분한 오라클에는 정녕 없나효? ;;;

S/W | 1639명이 읽었어요. 18.116.40.177

 0