Re: Undocumented SQL REVERSE function.

"Barry P. Grove" wrote:

> Hi,
>
> Just discovered the undocumented SQL REVERSE function; it's not the one
> from utl_raw, and it doesn't seem to be defined in /rdbms/admin/standard.sql,
> so I don't know why it might be there. Other than compatibility with
> SQLServer and/or DB2. Checked Oracle versions v7.3.4, v8.0.4, v8.1.7 and
> all of these support it, check out this otherwise innocuous function:
> select reverse('abcdefg') from dual;
>
> Am I missing something? Is this documented in some place I missed?
>
> Barry.

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.

Daniel Morgan Received on Thu Aug 01 2002 - 16:27:17 CDT