[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/,如需转载,请注明出处,否则将追究法律责任。