upper() in sql code example

Example 1: upper case sql

SELECT upper('Hello World');		-- HELLO WORLD
SELECT lower('Hello World');		-- hello world

Example 2: how to upper case in sql

SELECT UPPER(FIRST_NAME) , LOWER(LAST_NAME)
FROM CUSTOMERS ;