Database Administration (MOSC)

MOSC Banner

alter nls_currency

edited Aug 3, 2011 3:19AM in Database Administration (MOSC) 3 commentsAnswered
Hallo!I am trying to change nls_currency to 'Y' in Oracle 11.2.0.1.0 but when I restart the instance the value remans as $.I am trying to change nls_currency as below

 alter session set NLS_CURRENCY='Y';

I then restart the instance and when I run

select * from nls_database_parameters ORDER BY PARAMETER;

The value comes out as

NLS_CURRENCY   $

Please assist in changing this.

Thanks.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center