上一篇
Oracle数据库版本查询的正确步骤和常用方法有哪些?
- 数据库
- 2025-11-19
- 8
要查看Oracle数据库版本,您可以使用多种方法,以下是一些常用的方法:


使用SQL查询
在SQL*Plus或PL/SQL Developer等Oracle数据库客户端中,可以直接执行以下SQL查询来获取数据库版本信息:

SELECT * FROM v$version;
这条查询会返回多个行,其中包含数据库的版本信息,以下是查询结果的部分示例:
| NAME | VALUE |
|---|---|
| Oracle Database Release 19.0.0.0 Production | |
| Version 19.0.0.0.0 | |
| V Release 19.0 | |
| Patch level patch 0 | |
| Platform name | Oracle Linux 7.6 64bit Server |
| System name | orcl |
| Oracle home | /u01/app/oracle/product/19.0.0/dbhome_1 |
| DB name | orcl |
| Instance name | orcl |
| Redo thread count | 1 |
| Redo log groups count | 2 |
| Redo log members count | 4 |
| Database block size | 8192 |
| Block size | 8192 |
| Compatible with RDBMS | 0.0.0.0 |
| Oracle home release | 0.0.0.0 |
| Oracle release | 0.0.0.0 |
| ORACLE_HOME | /u01/app/oracle/product/19.0.0/dbhome_1 |
| ORACLE_SID | orcl |
| NLS_LANG | AMERICAN_AMERICA.WE8ISO8859P1 |
| NLS_CHARACTERSET | WE8ISO8859P1 |
| NLS_NCHAR_CHARACTERSET | AL16UTF16 |
| NLS_CALENDAR | GREGORIAN |
| NLS_DATE_FORMAT | DDMONRR HH.MI.SS AM |
| NLS_TIMESTAMP_FORMAT | DDMONRR HH.MI.SS.XX AM |
| NLS_TIMESTAMP_TZ_FORMAT | DDMONRR HH.MI.SS.XX AM TZR |
| NLS_TIME_FORMAT | HH.MI.SS AM |
| NLS_SORT | BINARY |
| NLS_COMP | BINARY |
| NLS_DATE_LANGUAGE | AMERICAN |
| NLS_NCHAR_SORT | BINARY |
| NLS_NCHAR_COLLATION | BINARY |
| NLS_CHARACTERSET_LIMITATION | N/A |
| NLS_CHARACTERSET_REPLACEMENT | N/A |
| NLS_LENGTH_SEMANTICS | BYTE |
| NLS_NCHAR_LENGTH_SEMANTICS | BYTE |
| NLS_TIMESTAMP_LENGTH_SEMANTICS | BYTE |
| NLS_TIMESTAMP_TZ_LENGTH_SEMANTICS | BYTE |
| NLS_TIMESTAMP_TZ_FORMAT_LENGTH | BYTE |
| NLS_TIMESTAMP_FORMAT_LENGTH | BYTE |
| NLS_DATE_FORMAT_LENGTH | BYTE |
| NLS_TIME_FORMAT_LENGTH | BYTE |
| NLS_SORT_LENGTH | BYTE |
| NLS_COMP_LENGTH | BYTE |
| NLS_CALENDAR_LENGTH | BYTE |
| NLS_DATE_LANGUAGE_LENGTH | BYTE |
| NLS_NCHAR_SORT_LENGTH | BYTE |
| NLS_NCHAR_COLLATION_LENGTH | BYTE |
| NLS_CHARACTERSET_LIMITATION_LENGTH | BYTE |
| NLS_CHARACTERSET_REPLACEMENT_LENGTH | BYTE |
| NLS_LENGTH_SEMANTICS_LENGTH | BYTE |
| NLS_NCHAR_LENGTH_SEMANTICS_LENGTH | BYTE |
| NLS_TIMESTAMP_LENGTH_SEMANTICS_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_LENGTH_SEMANTICS_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_FORMAT_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_FORMAT_LENGTH_LENGTH | BYTE |
| NLS_DATE_FORMAT_LENGTH_LENGTH | BYTE |
| NLS_TIME_FORMAT_LENGTH_LENGTH | BYTE |
| NLS_SORT_LENGTH_LENGTH | BYTE |
| NLS_COMP_LENGTH_LENGTH | BYTE |
| NLS_CALENDAR_LENGTH_LENGTH | BYTE |
| NLS_DATE_LANGUAGE_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_SORT_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_COLLATION_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_LIMITATION_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_REPLACEMENT_LENGTH_LENGTH | BYTE |
| NLS_LENGTH_SEMANTICS_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_LENGTH_SEMANTICS_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_LENGTH_SEMANTICS_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_LENGTH_SEMANTICS_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_FORMAT_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_FORMAT_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_FORMAT_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIME_FORMAT_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_SORT_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_COMP_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CALENDAR_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_LANGUAGE_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_SORT_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_COLLATION_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_LIMITATION_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_REPLACEMENT_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIME_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_SORT_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_COMP_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CALENDAR_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_LANGUAGE_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_SORT_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_COLLATION_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_LIMITATION_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_REPLACEMENT_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIME_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_SORT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_COMP_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CALENDAR_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_LANGUAGE_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_SORT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_COLLATION_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_LIMITATION_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_REPLACEMENT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIME_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_SORT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_COMP_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CALENDAR_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_LANGUAGE_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_SORT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_COLLATION_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_LIMITATION_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_REPLACEMENT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIME_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_SORT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_COMP_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CALENDAR_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_LANGUAGE_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_SORT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_COLLATION_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_LIMITATION_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_REPLACEMENT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIME_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_SORT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_COMP_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CALENDAR_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_LANGUAGE_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_SORT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_COLLATION_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_LIMITATION_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_REPLACEMENT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIME_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_SORT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_COMP_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CALENDAR_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_LANGUAGE_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_SORT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_COLLATION_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_LIMITATION_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_REPLACEMENT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIME_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_SORT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_COMP_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CALENDAR_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_LANGUAGE_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_SORT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_COLLATION_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_LIMITATION_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_REPLACEMENT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIME_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_SORT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_COMP_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CALENDAR_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_LANGUAGE_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_SORT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_COLLATION_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_LIMITATION_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_REPLACEMENT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIME_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_SORT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_COMP_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CALENDAR_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_LANGUAGE_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_SORT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_COLLATION_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_LIMITATION_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_CHARACTERSET_REPLACEMENT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_NCHAR_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_LENGTH_SEMANTICS_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_TZ_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIMESTAMP_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_DATE_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_TIME_FORMAT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_SORT_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| NLS_COMP_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH_LENGTH | BYTE |
| N |