Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

ASCII() returns the numeric value of the leftmost character of the string

SQL> Syntax: ASCII(<expression>) SQL> SQL> SQL> SELECT   2     ASCII('A')   uppercase_a,   3     ASCII('abc') lowercase_a from dual; UPPERCASE_A LOWERCASE_A ----------- -----------       65.00       97.00 SQL> SQL>