Monday, November 3, 2008

NLS_CURRENCY

Property

Description

Parameter type

String

Syntax

NLS_CURRENCY = currency_symbol

Default value

Derived from NLS_TERRITORY

Modifiable

ALTER SESSION

Range of values

Any valid character string, with a maximum of 10 bytes (not including null)

Basic

No

NLS_CURRENCY specifies the string to use as the local currency symbol for the L number format element. The default value of this parameter is determined by NLS_TERRITORY.

Note:

1. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = ‘NLS_CURRENCY’;

NAME

VALUE

IS

DEFAULT

ISSES_

MODIFIABLE

ISSYS_

MODIFIABLE

ISINSTANCE_

MODIFIABLE

IS

DEPRECATED

DESCRIPTION

nls_currency

TRUE

TRUE

FALSE

FALSE

FALSE

NLS local currency symbol

Oracle initializatoin parameters

No comments:

Post a Comment