oracle中的字符翻转函数,[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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/267265/viewspace-715034/，如需转载，请注明出处，否则将追究法律责任。