Re: Displaying session parameters in Oracle 7

Michel Cadot <micadot_at_netcourrier.com> wrote in message news:9aukv2$o3e$1_at_s1.read.news.oleane.net...
>
> "Kiloran" <kiloran_at_scotland.com> a écrit dans le message news:
 9auhid$3kn$1_at_newshost.mot.com...
> > This must be simple.....
> >
> > I can set a session parameter in Oracle 7:
> >
> > alter session set nls_date_format ='ddMonyyyy';
> >
> > How can I display the current value of nls_date_format, or any other
 session
> > parameter?
> >
> > -- Alan
> >
> >
>
> See v$nls_parameters or nls_session_parameters view.
>
> --
> Have a nice day
> Michel

Excellent! But suppose I have issued the statement:

   alter session set sql_trace=true;

how can I query the current value of sql_trace, which is not an nls parameter?

--Alan Received on Tue Apr 10 2001 - 09:33:14 CDT