How to view the oracle database version

There are many oracle database versions. The following describes how to view the system platform and the oracle database version. If you are interested in the oracle database version, take a look.

 
 

  
  
$ uname -a  
  
  
 
  
  
SunOS billing 5.8 Generic_108528-23 sun4u sparc SUNW,Ultra-4  
  
  
 
  
  
Sun Microsystems Inc. SunOS 5.8 Generic Patch October 2001  
  
  
 
  
  
$ sqlplus "/ as sysdba"  
  
  
 
  
  
     SQL*Plus: Release 9.2.0.4.0 - Production on Sun Nov 28 10:48:00 2004  
  
  
 
  
  
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.  
  
  
 
  
  
Connected to:  
  
  
 
  
  
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production  
  
  
 
  
  
With the Partitioning, OLAP and Oracle Data Mining options  
  
  
 
  
  
JServer Release 9.2.0.4.0 - Production  
  
  
 
  
  
SQL> select * from v$version;  
  
  
 
  
  
BANNER  
  
  
 
  
  
----------------------------------------------------------------  
  
  
 
  
  
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production  
  
  
 
  
  
PL/SQL Release 9.2.0.4.0 - Production  
  
  
 
  
  
CORE 9.2.0.3.0 Production  
  
  
 
  
  
TNS for Solaris: Version 9.2.0.4.0 - Production  
  
  
 
  
  
NLSRTL Version 9.2.0.4.0 - Production  
  
  
 
 
 

The preceding describes how to view the oracle database version.

Learn about the ORACLE resource role

Oracle data export and import Permissions

Oracle read-only user role creation

View oracle user permissions

Implementation of batch Oracle authorization