Checking value set via "set transaction" or "alter session"

From: Jack <jreid_at_stirlingonline.com>
Date: Fri, 7 Mar 2008 22:16:06 -0800 (PST)
Message-ID: <eb0d7e19-1284-46a1-8560-badf2d6d4e00@8g2000hse.googlegroups.com>


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)?

Lots of info on setting, haven't been able to find anything about checking these once they've been set.

Thank you, Jack Received on Sat Mar 08 2008 - 00:16:06 CST

Original text of this message