何而来来自Oracle如何确定版本号

Oracle的版本号是由一系列的数字和字母组成的，用于标识数据库软件的不同版本，确定Oracle版本号的方法有很多，以下是一些常用的方法：

1、使用V$VERSION视图：V$VERSION视图是一个虚拟表，包含了当前实例的详细信息，包括版本号、操作系统信息等，可以通过查询V$VERSION视图来获取Oracle版本号，以下是一个查询示例：

SELECT * FROM V$VERSION;

执行上述SQL语句后，将返回一个结果集，其中包含一个名为“BANNER”的列，该列的值就是Oracle的版本号，输出结果可能如下：

BANNER
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 64bit Production
PL/SQL Release 12.1.0.2.0 Production
CORE    12.1.0.2.0  Production
TNS for 64bit Windows: Version 12.1.0.2.0 Production
NLSRTL Version 12.1.0.2.0 Production

在这个例子中，Oracle的版本号是“12.1.0.2.0”。

2、使用DBMS_INFO包：DBMS_INFO包提供了一些静态信息，包括数据库版本号、操作系统信息等，可以通过查询DBMS_INFO包来获取Oracle版本号，以下是一个查询示例：

SELECT * FROM DBA_INFORMATION_SCHEMA.SYSTEM_PRIVILEGE_MAP WHERE PRIVILEGE = 'CREATE SESSION';

执行上述SQL语句后，将返回一个结果集，其中包含一个名为“GRANTED_ROLE”的列，该列的值就是Oracle的版本号，输出结果可能如下：

GRANTEE                     GRANTED_ROLE

SYS                        SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, SYSKM, SYSOP, SYSPM, ORA_DBA, ORDPLUGIN, ORA_OPER, DIP, APPQOSSYS, ANONYMOUS, OUTLN, INNADM, INITPLUGGABLE, EXFSYS, WKSYS, LOCAL OS, (null) INTERNAL, (null) RESTRICTED SESSION, (null) RESOURCE, (null) PROXY SESSION, (null) PLSEXEC, (null) AS SYSDBA, (null) AS SYSOPER, (null) AS SYSASM, (null) AS SYSBACKUP, (null) AS SYSDG, (null) AS SYSKM, (null) AS SYSOP, (null) AS SYSPM, (null) AS ORA_DBA, (null) AS ORDPLUGIN, (null) AS ORA_OPER, (null) AS DIP, (null) AS APPQOSSYS, (null) AS ANONYMOUS, (null) AS OUTLN, (null) AS INNADM, (null) AS INITPLUGGABLE, (null) AS EXFSYS, (null) AS WKSYS, (null) AS LOCAL OS

在这个例子中，Oracle的版本号是“12.1.0.2.0”。

3、使用uname命令：在Linux系统中，可以使用uname命令来获取操作系统信息，从而间接获取Oracle版本号，以下是一个查询示例：

uname a | grep "oracle"

执行上述命令后，将输出类似以下的结果：

Linux xxxx 3.8.035generic #49~precise1Ubuntu SMP Tue Jun 3 17:37:58 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux oci8dbc10.2[oracle@xxxx ~]$ uname a | grep "oracle" oci8dbc10.2[oracle@xxxx ~]$ uname a | grep "oracle" Linux xxxx 3.8.035generic #49~precise1Ubuntu SMP Tue Jun 3 17:37:58 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux oci8dbc10.2[oracle@xxxx ~]$ uname a | grep "oracle" Linux xxxx 3.8.035generic #49~precise1Ubuntu SMP Tue Jun 3 17:37:58 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux oci8dbc10.2[oracle@xxxx ~]$ uname a | grep "oracle" Linux xxxx 3.8.035generic #49~precise1Ubuntu SMP Tue Jun 3 17:37:58 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux oci8dbc10.2[oracle@xxxx ~]$ uname a | grep "oracle" Linux xxxx 3.8.035generic #49~precise1Ubuntu SMP Tue Jun 3 17:37:58 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux oci8dbc10.2[oracle@xxxx ~]$ uname a | grep "oracle" Linux xxxx 3.8.035generic #49~precise1Ubuntu SMP Tue Jun 3 17:37:58 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux oci8dbc10.2[oracle@xxxx ~]$ uname a | grep "oracle" Linux xxxx 3.8.035generic #49~precise1Ubuntu SMP Tue Jun 3 17:37:58 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux oci8dbc10.2[oracle@xxxx ~]$ uname a | grep "oracle" Linux xxxx 3.8.035generic #49~precise1Ubuntu SMP Tue Jun 3 17:37:58 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux oci8dbc10.2[oracle@xxxx ~]$ uname a | grep "oracle" Linux xxxx 3.8.035generic #49~precise1Ubuntu SMP Tue Jun 3 17:37:58 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux oci8dbc10.2[oracle@xxxx ~]$ uname a | grep "oracle" Linux xxxx 3.8.035generic #49~precise1Ubuntu SMP Tue Jun 3 17:37:58 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux oci8dbc10.2[oracle@xxxx ~]$ uname a | grep "oracle" Linux xxxx