Ramshankar MG
Oracle DBA
Saturday, December 8, 2012
How to find ORACLE HOME from database
SELECT substr(file_spec,1,instr(file_spec,'lib')-2) ORACLE_HOME FROM dba_libraries WHERE library_name='DBMS_SUMADV_LIB';
or
var OHM varchar2(100);
EXEC dbms_system.get_env('ORACLE_HOME', :OHM) ;
PRINT OHM
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment