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