thanks for that , sorry I don't really understand what you mean by env var
or registry key. Are you saying i need to chnage a registry setting on the
server?
Sybrand Bakker <postmaster_at_sybrandb.demon.nl> wrote in message
news:942963305.27130.0.pluto.d4ee154e_at_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 Fri Nov 19 1999 - 01:39:10 CST
