Oracle ASCII Function - SQL Snipplr Social Repository

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

Choose a language for easy browsing: