반응형
ORACLE_HOME
-
ORACLE_HOME (오라클 홈디렉토리) 경로 data dictionary에서 조회하기.DBMS/Oracle 2008. 9. 17. 10:39
Unix/Linux ----------------------------------------------------------------------------- SELECT SUBSTR(file_spec, 1, INSTR(file_spec, '/', -1, 2) -1) FROM dba_libraries WHERE library_name = 'DBMS_SUBADV_LIB'; ---------------------------------------------------------------------------------------- Windows ------------------------------------------------------------------------------- SELECT SUBST..