Oracle ASCII Function


/ Published in: SQL
Save to your folder(s)

A few examples of the Oracle ASCII function.


Copy this code and paste it in your HTML
  1. --ASCII
  2.  
  3. --Example 1
  4. SELECT ASCII('B') FROM dual;
  5.  
  6. --Example 2
  7. SELECT ASCII('é') FROM dual;
  8.  
  9. --Example 3
  10. SELECT ASCII('Complete') FROM dual;
  11.  
  12. --Example 4
  13. SELECT first_name, last_name
  14. FROM student
  15. WHERE ASCII(SUBSTR(last_name, 1, 1)) = '67';

URL: http://www.databasestar.com/oracle-ascii/

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.