[20120117]函数反转字符串reverse.txt

[20120117]函数反转字符串reverse.txt
SQL> select * from v$version ;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE    10.2.0.3.0      Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

SQL> select reverse('abcd 123') from dual;
REVERSE(
--------
321 dcba

 查看手册没有这么命令,估计是oracle内部使用的,存在一个问题,如果变量使用数值,出现如下错误:

SQL> select reverse(123) from dual;
REVERSE(123)
------------
  -9.900E+77

*** glibc detected *** double free or corruption (out): 0x000000000058d590 ***
rlwrap: warning: sqlplus killed by SIGABRT.
rlwrap has not crashed, but for transparency,
it will now kill itself (without dumping core)with the same signal

Aborted

在11G下测试:

SQL> select * from v$version ;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

SQL> select reverse('abcd 123') from dual ;
REVERSE(
--------
321 dcba

SQL> select reverse(123) from dual ;
select reverse(123) from dual
               *
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected CHAR got NUMBER