Revision: 71247
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
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