Simple demo for UPPER() function: convert string to upper case
SQL> SELECT UPPER('Hello There') AS UPPER FROM Dual; UPPER ----------- HELLO THERE SQL>