Re: Undocumented SQL REVERSE function.

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.

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader

Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.