Re: Checking value set via "set transaction" or "alter session"
Date: Sat, 08 Mar 2008 10:38:23 +0100
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:
> For the transaction state I don't know.
> Check out the Reference manual for this:
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