Friday, April 13, 2012

How to find ORACLE_HOME path with in Database

In 9i:

SELECT substr(file_spec,1,instr(file_spec,'lib')-2) ORACLE_HOME FROM dba_libraries
WHERE library_name='DBMS_SUMADV_LIB';


In 10g:

SQL > var OHM varchar2(100);
SQL > EXEC dbms_system.get_env('ORACLE_HOME', :OHM) ;
SQL > PRINT OHM

Linux/Unix:
echo $ORACLE_HOME

3 comments:

  1. It has been simply incredibly generous with you to provide openly what exactly many individuals would’ve marketed for an eBook to end up making some cash for their end, primarily given that you could have tried it in the event you wanted "Oracle Training in Bangalore".

    ReplyDelete
  2. Thank you for posting informative insights, I think we have got some more information to share with! Do check out Data Science Training in Chennai and let us know your thoughts. Let’s have great learning!

    ReplyDelete
  3. Slot Machines | Online Gambling Casinos 2021
    This 토토 사이트 제작 article will describe casinos that offer slots and 암호화폐란 table 총판모집 games. 1 1 토토 Our list goes into 바카라 규칙 detail about the casino features. All

    ReplyDelete