Re: Displaying session parameters in Oracle 7

"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