Oracle ASCIISTR function

Preamble

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

Syntax of the Oracle/PLSQL function ASCIISTR

ASCIISTR( string_id )

• string_id – is a string of any character set you want to convert to an ASCII character set base string.

The ASCIISTR function returns a string value.

ASCIISTR function in the following versions of Oracle/PLSQL

Let’s consider some examples of the ASCIISTR function and learn how to use the ASCIISTR function in Oracle/PLSQL.

SELECT ASCIISTR('ABACDE') FROM DUAL;

--Result: AB\00C4CDE

SQL functions ASCII , ASCIISTR , CHR , COMPOSE , CONCAT

About Enteros

​​​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​