ASCII() returns the numeric value of the leftmost character of the string. : ASCII « Char Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Char Functions
  3. ASCII

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>








Related examples in the same category

1.Ascii: Gives the ASCII value of the first character of a string
2.ASCII('A') ASCII('Z') ASCII('A') ASCII('Z') ASCII('ABC')