tech on the net
Home About Us Feedback Site Map


Access Excel Word


SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker


C Language


ASCII Table Linux UNIX Java Clipart Joke of the Moment
Share this page:

Oracle/PLSQL: ASCIISTR Function

Learn how to use the Oracle/PLSQL ASCIISTR function with syntax and examples.


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


The syntax for the Oracle/PLSQL ASCIISTR function is:

ASCIISTR( string )

Parameters or Arguments

string is a string in any character set that you want converted to an ASCII string in the database character set.

Applies To

The ASCIISTR function can be used in the following versions of Oracle/PLSQL:

  • Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i


Let's look at some Oracle ASCIISTR function examples and explore how to use the ASCIISTR function in Oracle/PLSQL.

For example:

ASCIISTR('A B C Ä Ê') would return 'A B C \00C4 \00CA'
ASCIISTR('A B C Õ Ø') would return 'A B C \00D5 \00D8'
ASCIISTR('A B C Ä Ê Í Õ Ø') would return 'A B C \00C4 \00CA \00CD \00D5 \00D8'