GENERATING AN ENVIROMENT FILE FROM PL/SQL
REQUEST I want to generate the current Oracle database environment file by querying a database. RELATED GETTING THE VALUE OF AN ENVIRONMENT VARIABLE THROGHT PL/SQL BLOCK SOLUTION ——————————————————- — Victor Khalturin — $Header 14:22 30.01.2018 — — Script generates the current environment…
QUERYING THE ORACLE_HOME PATH FROM A DATABASE
REQUEST I want to get the ORACLE_HOME path by querying the database. RELATED GETTING THE VALUE OF AN ENVIRONMENT VARIABLE THROGHT PL/SQL BLOCK SOLUTION DBMS_SYSTEM COL ORACLE_HOME FOR A30 VARIABLE ORACLE_HOME VARCHAR2(100); EXEC DBMS_SYSTEM.GET_ENV(‘ORACLE_HOME’,:ORACLE_HOME); PRINT ORACLE_HOME ORACLE_HOME —————————— /oracle/product/12.2.0.1 DBA_LIBRARIES…
GETTING THE VALUE OF AN ENVIRONMENT VARIABLE THROGHT PL/SQL BLOCK
REQUEST I want to get a value of the specific environment variable by querying a database. SOLUTION First, define a variable oracle@dbpilot.net: export MYVAR=”My Variable” oracle@dbpilot.net: echo $MYVAR My Variable A value of any variable can be retrieved through DBMS_SYSTEM.GET_ENV procedure COL OS_VAR…
Categories
- Linux (5)
- Networker (1)
- Oracle (41)
- Account (2)
- AWR (1)
- Database Errors (2)
- Datapump (1)
- Enterprise Manager (10)
- Environments (4)
- Interview (1)
- NLS (1)
- Objects (1)
- Objects DDL (2)
- PL/SQL (4)
- UTL_FILE (4)
- Prerequisites (1)
- Redologs (1)
- Segment Shrink (1)
- Session (3)
- Spfile (3)
- SQL PLUS (1)
- Spooling (1)
- Statistics (2)