By using our website, you agree to the use of our cookies.
By using our website, you agree to the use of our cookies.

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 file. — You must have…

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 COL "ORACLE_HOME" FOR A30 SELECT…

WordPress Theme built by Shufflehound. dbpilot.net by Victor Khalturin ©