Oracle 参数 BLANK_TRIMMING 官方解释,作用,如何配置最优化建议

本站中文解释

BLANK_TRIMMING参数用来控制数据库中的表中的空白字符。如果该参数设置为TRUE,则当表中的空白字符被检索时,它们将被裁剪或删除,如果设置为FALSE,则这些空格字符将保持不变。

正确设置BLANK_TRIMMING参数,需要根据具体情况进行设置,如果需要对文本中的空格进行裁剪,可以将其设置为TRUE;如果要保持文本中的空白字符,可以将其设置为FALSE。

官方英文解释

BLANK_TRIMMING specifies the data assignment semantics of character datatypes.

Property Description

Parameter type

Boolean

Default value

false

Modifiable

No

Modifiable in a PDB

Yes

Range of values

true | false

Basic

No

Values

  • TRUE

    Allows the data assignment of a source character string or variable to a destination character column or variable even though the source length is longer than the destination length. In this case, however, the additional length over the destination length must be all blanks, else an exception condition is raised. This value complies with the semantics of SQL-92 Transitional Level and above.

  • FALSE

    Disallows the data assignment if the source length is longer than the destination length and reverts to SQL92 Entry Level semantics.

See Also:

Oracle Database
Globalization Support Guide
for more information on how using this parameter can help prevent data truncation issues during character set migration


数据运维技术 » Oracle 参数 BLANK_TRIMMING 官方解释,作用,如何配置最优化建议