Wednesday 29 October 2014

DB : Getting the database environment variable in SQL propmt

Solution:

var OHM varchar2(1000);
EXEC dbms_system.get_env('ORACLE_HOME', :OHM);
print OHM

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Oracle : Database Startup Time

 Oracle Instance Startup Time SET LINES 2000 SET PAGES 9999 COLUMN INSTANCE_NAME FOR A20 SELECT     instance_name,     to_char(startup_time,...