Quick Search:


	CODE Oracle PL/SQL Code Library


	FORUM Oracle Discussion & Chat

The Oracle ASCII Function [Return To Index]

Jump to:

Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: ASCII

Definition:
The ASCII function gets the ASCII value of a character.

ASCII function syntax:

ASCII(ch VARCHAR2 

CHARACTER SET ANY_CS) 

RETURN PLS_INTEGER;

For example:

SELECT ASCII('A') FROM dual;

SELECT ASCII('Z') FROM dual;

SELECT ASCII('a') FROM dual;

SELECT ASCII('z') FROM dual;

SELECT ASCII(' ') FROM dual;

Related Links:

Related Code Snippets:

String Functions: ASCII - Returns the ASCII number code that represents the specified character.
Generate ASCII table - Generates the full ASCII table. Useful for reference or decoding, testing, etc.
ASCIISTR - ASCIISTR takes as its argument a string, or an expression that resolves to a string, in...

Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us