Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Altering session
try
select sysdate from dual;
"Alain Kreienbuhl" <alain.kreienbuhl_at_fisystem.com> wrote in 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.
>
Received on Fri Jul 27 2001 - 18:36:22 CDT