ASCII Function in PL/SQL

ASCII function returns the NUMBER corresponding to the first Character of expression.

Syntax for using ASCII Function

ASCII(character);

some examples follow

SQL>SELECT ASCII(a) from DUAL;

this query would return 97

SQL>SELECT ASCII(a) from DUAL;

this query would would return 65

1 comment

Read the comments left by other users below, or:

Get your own gravatar by visiting gravatar.com Berbatov
#1. July 19th, 2010, at 2:44 PM.

Between me and my husband we’ve owned more MP3 players over the years than I can count, including Sansas, iRivers, iPods (classic & touch), the Ibiza Rhapsody, etc. But, the last few years I’ve settled down to one line of players. Why? Because I was happy to discover how well-designed and fun to use the underappreciated (and widely mocked) Zunes are.

Leave your comment...

If you want to leave your comment on this article, simply fill out the next form:




CAPTCHA Image CAPTCHA Audio
Refresh Image

You can use these XHTML tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> .