Oracle String/Char Function - Oracle/PLSQL ASCIISTR Function

ASCIISTR(x) converts x to an ASCII string, where x may be a string in any character set.

This Oracle tutorial explains how to use the Oracle/PLSQL ASCIISTR function.

Oracle/PLSQL ASCIISTR function converts a string in any character set to an ASCII string using the database character set.

Syntax

The syntax for the Oracle/PLSQL ASCIISTR function is:

ASCIISTR( string )

string can be in any character set.

Example

The following code shows how to use Oracle ASCIISTR function.


SQL> select asciistr('A B C  E') from dual;
-- from  w w w  . j a v a  2  s  .c  o  m
ASCIISTR('ABC
-------------
A B C \017D E

SQL>

ASCIISTR('A B C  ')
--------------------
 'A B C \00C4 \00CA'
 
ASCIISTR('A B C  ')
--------------------
 'A B C \00D5 \00D8'

           ASCIISTR('A B C     ')
-------------------------------------
'A B C \00C4 \00CA \00CD \00D5 \00D8'