Re: Checking value set via "set transaction" or "alter session"
From: Thomas Kellerer <FJIFALSDGVAF_at_spammotel.com>
Date: Sat, 08 Mar 2008 10:38:23 +0100
Message-ID: <63f54gF277oi9U2@mid.individual.net>
>
> For the NLS parameter see:
> <http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_4220.htm#sthref2021>
>
>
>
> For the transaction state I don't know.
> Check out the Reference manual for this:
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc.htm
Date: Sat, 08 Mar 2008 10:38:23 +0100
Message-ID: <63f54gF277oi9U2@mid.individual.net>
Thomas Kellerer wrote on 08.03.2008 10:36:
> Jack wrote on 08.03.2008 07:16:
>> This seemed like it would be a simple question to answer, but I can't >> find anything on either. >> >> Can anyone shed some light on how to determine the value I have used >> for "set transaction" (say to "read only") and for "alter >> session" (say to change the NLS_DATE_FORMAT)? >>
>
> For the NLS parameter see:
> <http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_4220.htm#sthref2021>
>
>
>
> For the transaction state I don't know.
> Check out the Reference manual for this:
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc.htm
And the sys_context function might also be interesting for you:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/functions165.htm#i1038176 Received on Sat Mar 08 2008 - 03:38:23 CST