www.1q.co.kr(park1q.com)

ID :  Password : Auto  

   ȸ¿ø:0¸í / ¼Õ´Ô:0¸í
 

 

Technote

ÀÚ·á ¹× °ü¸®ÆÁ

  • DBA Notes
  • Q & A

    ºÏ¸¶Å©
  • Asktom
       (Oracle ÀÇ ´ëÇ¥ Forum)
  • Technical Bulltin(KR)
       (±â¼úÁö¿ø°Ô½ÃÆÇ)
  • Dbazine

  •  

     


     get ORACLE_HOME by SQL
    park1q  2017-09-27 17:57:40, Á¶È¸ : 4,470, Ãßõ : 1177


    * Ȥ½Ã³ª Çؼ­ ã¾Æ ºÃ´Âµ¥..´äÀÌ Àֳ׿ä..
     
    SQL> select substr(file_spec, 1, instr(file_spec, '/', -1, 2) - 1) ORACLE_HOME
      2    from dba_libraries
      3   where library_name = 'DBMS_SUMADV_LIB'
      4  /
     
    ORACLE_HOME
    --------------------------------------------------------------------------------
    /home/oracle/10.2.0
     
    ´Ü, À©µµ¿ìÁî °è¿­¿¡¼­´Â ÀÌ»óÇÏ°Ô ³ª¿À³×¿ä..Âü°íÇϼ¼¿ä..
    ORACLE_HOME
    --------------------------------------------------------------------------------
    C:/ADE/aime_060128/oracle
     


      ÃßõÇϱâ ÇÁ¸°Æ®   ¸ñ·Ïº¸±â

    Copyright 1999-2025 Zeroboard

     

     
     
    [Today:5 / Total:172122]    Design by p@rk1q