The Oracle and PL/SQL UPPER function converts all letters in the specified string to uppercase.
The general format is:
UPPER(char)
Example 1:
SELECT UPPER('John Williams') FROM DUAL;
returns:
JOHN WILLIAMS
The Oracle and PL/SQL UPPER function converts all letters in the specified string to uppercase.
The general format is:
UPPER(char)
Example 1:
SELECT UPPER('John Williams') FROM DUAL;
returns:
JOHN WILLIAMS