Oracle ENVIRONMENT VARIABLES
Version 21c

Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows
 
Product Homes
Query to identify home directories for Oracle products SELECT sys_context('USERENV', 'ORACLE_HOME')
FROM dual;

SYS_CONTEXT('USERENV','ORACLE_HOME')
------------------------------------------
/u01/app/oracle/product/21.0.0.0/dbhome_1
 
Version and Release Number
Version and Release Number Demo SQL> DEFINE _O_VERSION
DEFINE _O_VERSION = "Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.1.0.0.0" (CHAR)

SQL> DEFINE _O_RELEASE
DEFINE _O_RELEASE = "2101000000" (CHAR)

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_SYSTEM.GET_ENV
Exception Handling
System Events
What's New In 21c
What's New In 26ai

Morgan's Library Page Footer
This site is maintained by Daniel Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved