Re: Currency Symbols

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 18 Nov 1999 23:13:58 +0100
Message-ID: <942963305.27130.0.pluto.d4ee154e@news.demon.nl>

This can be accomplished by either setting NLS_TERRITORY or NLS_ISO_CURRECNY and if you want them to be permanent they need to env var or registry key. If they should be non-permanent use alter session. There is a view v$nls_valid_values where you can see which values can be used.

Hth,

--
Sybrand Bakker, Oracle DBA
John <jbraddon_at_bluecarrots.com> wrote in message news:3834641d_1_at_news1.vip.uk.com...
> My database reports currency in $ but i need it in £, I've tried messing
> around with nls parameters in the init.ora but to no avail as i don't
really
> know what i should be doing. Any help would greatly appreciated.
>
> John
>
>
>
>
>
>
Received on Thu Nov 18 1999 - 16:13:58 CST