SQL UPPER() Function

SQL UPPER() function return uppercase character in every word.

SQL UPPER() function supported Oracle SQL version

  • Oracle 8i
  • Oracle 9i
  • Oracle 10g
  • Oracle 11g
  • Oracle 12c
  • Oracle 18c

Syntax

UPPER(char/string)

Example

Consider following example return the uppercase string of given string argument.

SQL> SELECT UPPER('Opal kole') "UPPER" FROM DUAL;

UPPER
---------
OPAL KOLE