ASCIISTR function in Oracle

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.

Please Share