Undocumented SQL REVERSE function.

From: Barry P. Grove <bggrove_at_barrysoft.com>
Date: 1 Aug 2002 14:03:14 -0700
Message-ID: <dcf4ee05.0208011303.3143f41a@posting.google.com>

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. Received on Thu Aug 01 2002 - 16:03:14 CDT