Return to Snippet

Revision: 71247
at January 25, 2017 05:30 by bbrumm


Initial Code
--Example 1
SELECT UPPER('Database Star') FROM dual;

--Example 2
SELECT UPPER('Database 2016') FROM dual;

--Example 3
SELECT first_name, last_name
FROM customers
WHERE UPPER(first_name) = 'JOHN';

--Example 4
SELECT first_name, last_name, country
FROM customers
WHERE UPPER(country) = UPPER('usa');



--Example 5
SELECT first_name, last_name, country
FROM customers
WHERE UPPER(country) LIKE ('U%');


--Example 6
SELECT first_name, last_name, country
FROM customers
WHERE UPPER(first_name) LIKE UPPER('m%');


--Example 7
SELECT UPPER(SUBSTR('database star',1,1)) || SUBSTR('database star',2) AS upper_text FROM dual;

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

Initial Description
A few examples of the UPPER function.

Initial Title
Oracle UPPER Function

Initial Tags
sql, Oracle

Initial Language
SQL