Posted By

bbrumm on 02/07/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 02/07/17 08:27am

Statistics

Viewed 685 times

Favorited by 0 user(s)

Related snippets

Oracle ASCII Function

/ Published in: SQL

A few examples of the Oracle ASCII function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

--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';