Return to Snippet

Revision: 71287
at February 7, 2017 08:27 by bbrumm


Initial Code
--ASCII

--Example 1
SELECT ASCII('B') FROM dual;

--Example 2
SELECT ASCII('é') FROM dual;

--Example 3
SELECT ASCII('Complete') FROM dual;

--Example 4
SELECT first_name, last_name
FROM student
WHERE ASCII(SUBSTR(last_name, 1, 1)) = '67';

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

Initial Description
A few examples of the Oracle ASCII function.

Initial Title
Oracle ASCII Function

Initial Tags
sql, Oracle

Initial Language
SQL