Database Administration (MOSC)

MOSC Banner

NLS_CURRENCY change to Pound

edited May 8, 2017 5:04AM in Database Administration (MOSC) 1 commentAnswered

One of my stakeholder asked me to change the nls_currency to pound (£) in the nls_database_parameters. I am unable to change the parameter.

Few current parameters on their system:  (querying NLS_DATABASE_PARAMETERS)

PARAMETER                           VALUE

----------------------------------- -----------------------------------

NLS_CHARACTERSET                    AL32UTF8

NLS_CURRENCY                        Ç

NLS_DATE_FORMAT                     DD/MM/RR HH24:MI:SS

NLS_DATE_LANGUAGE                   ENGLISH

NLS_ISO_CURRENCY                    UNITED KINGDOM

NLS_LANGUAGE                        ENGLISH

NLS_TERRITORY                       UNITED KINGDOM

NLS_TIMESTAMP_FORMAT                DD/MM/RR HH24:MI:SSXFF

NLS_TIMESTAMP_TZ_FORMAT             DD/MM/RR HH24:MI:SSXFF TZR

NLS_TIME_FORMAT                     HH24.MI.SSXFF

NLS_TIME_TZ_FORMAT                  HH24.MI.SSXFF TZR

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center