Advanced Search

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