Re: Altering session

From: Alain Kreienbuhl <alain.kreienbuhl_at_fisystem.com>
Date: Mon, 16 Jul 2001 14:51:26 +0200
Message-ID: <3B52E34E.4AB95AB9@fisystem.com>

Thanks (Merci :-) Michel,

I'm getting the following results :

SQL> select rpad(parameter,20), rpad(value,20) from v$nls_parameters;

RPAD(PARAMETER,20) RPAD(VALUE,20)

-------------------- --------------------
NLS_LANGUAGE         FRENCH
NLS_TERRITORY        FRANCE
NLS_CURRENCY         F
NLS_ISO_CURRENCY     FRANCE
NLS_NUMERIC_CHARACTE ,.
NLS_CALENDAR         GREGORIAN
NLS_DATE_FORMAT      YYYY-MM-DD HH24:MI:S
NLS_DATE_LANGUAGE    FRENCH
NLS_CHARACTERSET     WE8ISO8859P1
NLS_SORT             FRENCH

NLS_NCHAR_CHARACTERS WE8ISO8859P1 11 ligne(s) sÚlectionnÚe(s).

SQL> select rpad(name,20), rpad(value,20) from v$parameter where name like '%nls%';

RPAD(NAME,20) RPAD(VALUE,20)

-------------------- --------------------
nls_language         AMERICAN
nls_territory        AMERICA
nls_sort             _nul
nls_date_language    _nul
nls_date_format      _nul
nls_currency         _nul
nls_numeric_characte _nul
nls_iso_currency     _nul
nls_calendar         _nul

9 ligne(s) sÚlectionnÚe(s).

I guess this means that the database is US by default ( as shown in the v$parameter table) however the current session is using the french local as show in "v$nls_parameters". Is the this correct ?

I allways thought that v$nls_parameters was just a restriction of v$parameter... Looks like it's not. ..

Thanks
Alain.

Michel Cadot a écrit :

> "Alain Kreienbuhl" <alain.kreienbuhl_at_fisystem.com> a écrit dans le message news:
> 3B52BD16.D6412B8C_at_fisystem.com...
> > Hello,
> >
> > After issuing the following command :
> >
> > alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS';
> >
> > How can I check the session content ? I'd like to do something like a "
> > select * from session".
> > In which schema do Session belong to ?
> >
> > Thanks for your help.
> >
> > Alain.
> >
>
> You can see your current nls parameters in the v$nls_parameters,
> for instance:
> select value from v$nls_paramaters where parameter='NLS_DATE_FORMAT';
>
> You cannot see theses values for the other sessions.
>
> --
> Hope this helps
> Michel
Received on Mon Jul 16 2001 - 07:51:26 CDT