Asciistr – Oracle SQL Function

ASCIISTR takes a string argument and returns the ASCII equivalent. If any of the characters in the string are non ASCII, they are converted to the UTF-16xxxx format.

Syntax:

ASCIISTR(string)

Example:

SELECT ASCIISTR(‘a non-ascii char ŷ’ as RESULT FROM DUAL;

RESULT
————
a non-ascii char 0E7