REVERSE关键字之REVERSE函数
REVER
-----
54321
SQL> select reverse('Oracle') from dual;
REVERS
------
elcarO
SQL> select reverse('测试') from dual;
REVE
----
????
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_language string AMERICAN
'测试'
------
测试
REVERSE('测试')
---------------
允獠
DUMP('12345') DUMP(REVERSE('12345'))
---------------------------- ----------------------------
Typ=96 Len=5: 49,50,51,52,53 Typ=96 Len=5: 53,52,51,50,49
将'12345'的ASCII字码按逆序排列打印。
DUMP('ORACLE') DUMP(REVERSE('ORACLE'))
---------------------------------- ----------------------------------
Typ=96 Len=6: 79,114,97,99,108,101 Typ=96 Len=6: 101,108,99,97,114,79
DUMP('测试') DUMP(REVERSE('测试'))
----------------------------- -----------------------------
Typ=96 Len=4: 178,226,202,212 Typ=96 Len=4: 212,202,226,178