How to query the number of digits in oracle-Oracle-php.cn

How to query the number of digits in oracle

WBOY

Release： 2022-05-10 17:37:10

Original

7374 people have browsed it

Method: 1. Use "sqlplus /as sysdba" to query, 64-bit will display specific digit information, 32-bit will not be displayed; 2. Use "v$version" view query will display 64-bit digit information ;3. Use the "v$sql" view to query, the 32-bit output is an 8-digit hexadecimal number, and the 64-bit output is a 16-digit hexadecimal number.

How to query the number of digits in oracle

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to query the number of digits in oracle

Method 1: Use sqlplus

64 bits:

[oracle@qs-wg-db2 ~]$ sqlplus / as sysdba;
SQL*Plus: Release 10.2.0.5.0 - Productionon Sun Sep 25 08:57:22 2011
Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise EditionRelease 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Miningand Real Application Testing options
SQL>

Copy after login

If it is 64 bits, After connecting with sqlplus, the specific digit information will be displayed, but 32-bit will not be displayed.

32 bits:

C:/Users/Administrator.DavidDai>sqlplus/ as sysdba;
https://www.cndba.cn/Dave/article/1130
SQL*Plus: Release 11.2.0.1.0 Production onSun Sep 25 08:55:48 2011
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
https://www.cndba.cn/Dave/article/1130
Connected to:
Oracle Database 11g Enterprise EditionRelease 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Miningand Real Application Testing options

Copy after login

Method 2: View v$version view

32 bits:

SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------
Oracle Database 11g Enterprise EditionRelease 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Productionhttps://www.cndba.cn/Dave/article/1130
CORE   11.2.0.1.0      Production
TNS for 32-bit Windows: Version 11.2.0.1.0- Production
NLSRTL Version 11.2.0.1.0 - Production

Copy after login

64 bits:

SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise EditionRelease 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE   10.2.0.5.0      Production
TNS for Linux: Version 10.2.0.5.0 -Production
NLSRTL Version 10.2.0.5.0 – Production

Copy after login

Same as the first method, 64-bit will display the specific number of digits, but 32-bit will not.

Method 3: View v$sql view

32-bit: The output is 8-digit hexadecimal number

SQL> select address from v$sql whererownum<2;
ADDRESS
--------

Copy after login

64-bit: The output is 16 Hexadecimal number

SQL> select address from v$sql whererownum<2;
ADDRESS
----------------
0000000196FDF7D8

Copy after login

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to query the number of digits in oracle. For more information, please follow other related articles on the PHP Chinese website!