ORACLE ASCII() 함수

오라클에서 ASCII() 함수

ASCII returns the decimal representation(십진 표기법) in the database character set of the first character of char

 

 

SQL > SELECT last_name
            FROM employees
            WHERE ASCII(SUBSTR(last_name, 1, 1)) =76
            ORDER BY last_name ;

 

   --> Ladwig
        Landry
        Lee
        Livingston
        Lorentz

 

SQL> SELECT ASCII('\?') FROM DUAL;

   --> 92