Re: Checking value set via "set transaction" or "alter session"
Date: Sat, 8 Mar 2008 11:39:07 -0800 (PST)
On Mar 8, 4:16 am, vitalis..._at_gmail.com wrote:
> On 8 mar, 07:16, Jack <jr..._at_stirlingonline.com> wrote:
> > 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
> Which Oracle version?
> When and from where do you want to check those parameter values?
Sorry, my bad. DB version 10.2, I'd like to find these out through PL/ SQL. Received on Sat Mar 08 2008 - 13:39:07 CST