SQL> select str, asciistr(str) utf16_enc from unistr_sample;
STR UTF16_ENC
---------------- ------------------------------
here we go here we go
yes レッツら go yes \30EC\30C3\30C4\3089 go
here we are here we are
SQL> select str, asciistr(str) utf16_enc,
2 unistr(asciistr(str)) ucs2_dec
3 from unistr_sample;
STR UTF16_ENC UCS2_DEC
---------------- ------------------------------ ------------------------------
here we go here we go here we go
yes レッツら go yes \30EC\30C3\30C4\3089 go yes レッツら go
here we are here we are here we are