Re: SQL challenge - an undocumented feature.

This only works for me if I'm in the same session. If I go into another session
and do some transactions, then return to the first one, even if I do a commit;

the number doesn't change..

Jonathan Lewis wrote:

> I guess I should have made it clearer, but
> yes, the ....... was supposed to represent
> a missing item. In this case the expression:
>
> userenv('commitscn')
>
> which is just one of several userenv() options
> which don't appear in many documents.
>
> Details should be on the web-site in the next couple of hours
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
> Doug Cowles wrote in message <374AEF95.BA64DC6B_at_bigfoot.com>...
> >Looking forward to it appearing on the website. I don't get it. The
> periods
> >have to be an alias for something though because when I try it I just get
> "missing
> >epression". They're illegal as a variable name so there has to be some
> funny
> >business set up before this happens.
> >
> >Jonathan Lewis wrote:
> >>
> >> insert into test_table values (.......);
> >> 1 row inserted
Received on Fri Jun 04 1999 - 11:39:03 CDT