Posted By

bbrumm on 01/25/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 01/25/17 05:30am

Statistics

Viewed 884 times

Favorited by 0 user(s)

Related snippets

Oracle UPPER Function

/ Published in: SQL

A few examples of the UPPER function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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