NLS_LENGTH_SEMANTICS
Property
Description
Parameter
type
String
Syntax
NLS_LENGTH_SEMANTICS =
string
Example: NLS_LENGTH_SEMANTICS = 'CHAR'
Default
value
BYTE
Modifiable
ALTER
SESSION
Range of
values
BYTE |
CHAR
The session-level value of NLS_LENGTH_SEMANTICS
specifies the default length semantics to use for
VARCHAR2 and CHAR table columns,
user-defined object attributes, and PL/SQL variables in database
objects created in the session. This default may be overridden by
the explicit length semantics qualifiers BYTE and
CHAR in column, attribute, and variable
definitions.
会话级别的nls_length_semantics说明默认的char和varchar2,用户定义的对象属性,和pl/sql变量在数据库对象创建的长度语法。默认值会被显示说明的参数值覆盖。
The instance-level value of NLS_LENGTH_SEMANTICS
provides a default for the session-level value if
NLS_LENGTH_SEMANTICS it is not set explicitly by the
database client through the NLS_LENGTH_SEMANTICS
client environment variable (does not apply to JDBC Thin clients),
or the ALTER SESSION SET
NLS_LENGTH_S