How to get ORACLE_HOME from data dictionary
SQL> set autopri on
SQL> var oracle_home varchar2(255)
SQL> exec dbms_system.get_env('ORACLE_HOME',:ORACLE_HOME)
PL/SQL procedure successfully completed.
ORACLE_HOME
--------------------------------------------------------------------------------
/app/oracle/oracle/product/10.2.0/db_2
[@more@]
SQL> var oracle_home varchar2(255)
SQL> exec dbms_system.get_env('ORACLE_HOME',:ORACLE_HOME)
PL/SQL procedure successfully completed.
ORACLE_HOME
--------------------------------------------------------------------------------
/app/oracle/oracle/product/10.2.0/db_2
[@more@]
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/18921899/viewspace-1017259/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- How Oracle Uses the Data Dictionary (262)Oracle
- Get data style from ExcelExcel
- get_data_from_yml
- How to migrate data from Oracle to MSSQLSERVEROracleSQLServer
- [20201110]How to get the Data Guard broker configuration from a SQL query.txtSQL
- data dictionary（資料字典）
- About Static Data Dictionary ViewsView
- Export data from a data blockExportBloC
- Structure of the Data Dictionary : Base Tables (258)Struct
- How To Replicate Data from Oracle to Postgres Using GoldenGate (Doc ID 1544137.1OracleGo
- Public Synonyms for Data Dictionary Views (263)View
- Cache the Data Dictionary for Fast Access (264)AST
- Python演算法-How to sort a dictionary by valuePython演算法
- How to recover from USB pipe errorsError
- [轉]How to release space from databaseDatabase
- How to get propose products in Sales Order
- How to get SCN ,TIMESTAMP ,CHECKPOINT
- How to get complete sessions informationSessionORM
- How to get the donuts in Lode Runner 2
- How boltdb Write its Data?
- Unload data from oracleOracle
- Structure of the Data Dictionary : User-Accessible Views (259)StructView
- Step 9: Run Scripts to Build Data Dictionary Views (67)UIView
- how to get sharepoint lookup value
- Oracle HowTo:How to get Oracle SCN?Oracle
- How to get and set the system socket buffer in AIXAI
- How to get Timer Job History
- How to monitor data transaction on one table
- How to Rename a Server That Is Not a Data Store ServerServer
- Get your Windows product key from a scriptWindows
- how to move a MediaWiki wiki from one server to anotherServer
- SQL*Net more data from clientSQLclient
- note of Beginning Oracle SQL-Oracle Data Dictionary ViewsOracleSQLView
- Keeping the Data Dictionary Cache Hit Ratio at or above 95 Percent
- How to get the description of blast hit using blastdbcmd?AST
- jedis異常：Could not get a resource from the pool
- How To Copy Any Text To Clipboard From Terminal In UbuntuUbuntu
- How to return plain text from AWS Lambda & API GatewayAIAPIGateway