Re: Undocumented SQL REVERSE function.

In article <1e8276d6.0208012301.733c5775_at_posting.google.com>, you said (and I quote):
> Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3D49A7B2.D50B3490_at_exesolutions.com>...
>
> > Interesting. I especially enjoy
> >
> > SELECT REVERSE(12345) FROM dual;
> > and
> > SELECT REVERSE(SYSDATE) FROM dual;
> >
> > SELECT REVERSE(null) FROM dual brings SQL*Plus down in an
> > unceremonious crash.
>
> I don't think so (for EE 8.1.7.1.0 32-bit NT):
>
> TBD01/SYSTEM>connect dbolek_at_DB813.world
> Enter password: ******
> Connected.
> DB813/DBOLEK>SELECT REVERSE(null) FROM dual;
>
> R
> -
>
> Sounds right, reverse from NULL is NULL. Expected behaviour.
>

It dies if you do the sequence of events he did. Try doing the crazy ones: 12345 and sysdate. THEN do the null one. Or just try to exit SQL*Plus and see how it crashes. 8.1.7, Winblows 2K here.

-- 
Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam