Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Altering session

Re: Altering session

From: Dan White <dwhite_at_icimail.com>
Date: Fri, 27 Jul 2001 19:36:22 -0400
Message-ID: <9jsuc702gni@enews4.newsguy.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US