Re: How to reset after Alter Session

From: Sam <samevan_at_hotmail.com>
Date: 23 Jan 2003 08:44:12 -0800
Message-ID: <35a7dd54.0301230844.22425661@posting.google.com>

rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0301222202.743224f_at_posting.google.com>...
> samevan_at_hotmail.com (Sam) wrote in message news:<35a7dd54.0301221546.7abda787_at_posting.google.com>...
> > After I run ALTER SESSION.. such as
> >
> > ALTER SESSION SET SQL_TRACE = FALSE
> >
> > How do I set the session varible back to original state?
> >
> > Help?
>
>
> ALTER SESSION SET SQL_TRACE = TRUE
>
> Regards
> /Rauf Sarwar

As Stephan mentined that the original state could be TRUE or False. How do I set this back to original state? "ALTER SESSION SET SQL_TRACE" is only the example for this question. There are many SESSION variables we can alter, which we should be able to set back to their original states.

Thanks!

Sam Received on Thu Jan 23 2003 - 10:44:12 CST