ITPub博客

首页 > Linux操作系统 > Linux操作系统 > NLS_NUMERIC_CHARACTERS(转)

NLS_NUMERIC_CHARACTERS(转)

原创 Linux操作系统 作者:tochar 时间:2007-07-27 00:00:00 0 删除 编辑

NLS_NUMERIC_CHARACTERS

Parameter type

String

Syntax

NLS_NUMERIC_CHARACTERS =

"decimal_character group_separator"

Default value

Derived from NLS_TERRITORY

Parameter class

Dynamic: ALTER SESSION

NLS_NUMERIC_CHARACTERS specifies the characters to use as the group separator and decimal character. It overrides those characters defined implicitly by NLS_TERRITORY. The group separator separates integer groups (that is, thousands, millions, billions, and so on). The decimal separates the integer portion of a number from the decimal portion.

You can specify any character as the decimal or group separator. The two characters specified must be single-byte and must be different from each other. The characters cannot be any numeric character or any of the following characters: plus (+), minus sign (-), less than sign (<), greater than sign (>). Either character can be a space.

For example, if you wish to specify a comma as the decimal character and a space as the group separator, you would set this parameter as follows:

NLS_NUMERIC_CHARACTERS = ", "

NLS_NUMERIC_CHARACTERS

Parameter type

String

Syntax

NLS_NUMERIC_CHARACTERS =

"decimal_character group_separator"

Default value

Derived from NLS_TERRITORY

Parameter class

Dynamic: ALTER SESSION

NLS_NUMERIC_CHARACTERS specifies the characters to use as the group separator and decimal character. It overrides those characters defined implicitly by NLS_TERRITORY. The group separator separates integer groups (that is, thousands, millions, billions, and so on). The decimal separates the integer portion of a number from the decimal portion.

You can specify any character as the decimal or group separator. The two characters specified must be single-byte and must be different from each other. The characters cannot be any numeric character or any of the following characters: plus (+), minus sign (-), less than sign (<), greater than sign (>). Either character can be a space.

For example, if you wish to specify a comma as the decimal character and a space as the group separator, you would set this parameter as follows:

NLS_NUMERIC_CHARACTERS = ", "

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9078678/viewspace-45120/,如需转载,请注明出处,否则将追究法律责任。

下一篇: NLS_SORT(转)
请登录后发表评论 登录
全部评论

注册时间:2007-12-11

  • 博文量
    118
  • 访问量
    787099