Upper – Oracle SQL Function

UPPER returns a VARCHAR2 string that contains all the characters of argument1 in uppercase.

The argument1 can be a CHAR, VARCHAR2,NCHAR,NVARCHAR2,CLOB or NCLOB data type.

Example:

SELECT UPPER(‘oracle rocks’) as RESULT from DUAL;

RESULT
——————
ORACLE ROCKS