Re: Altering session

"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