ASCIISTR is also one of the vital string/char functions of Oracle. It is used to return the ASCII code for a string in any character set. It uses the database character set. The ASCIISTR function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i.
Syntax:
ASCIISTR( string )
Parameters:
string: It is used to specify the string, for which the ASCII code needs to be retrieved.
Example 1:
ASCIISTR( 'X Y Z Ì Ð' ) |
Output:
‘X Y Z \00CC \00D0’
Explanation:
The ASCII code for Ì is CC and for Ð is DO and so is the result.