The UPPER function converts a string to uppercase.
Syntax
UPPER(c1)
Parameters
| Parameter | Description |
|---|---|
| c1 | The string. The string type can be CHAR, VARCHAR2, NCHAR, NVARCHAR2, or CLOB. |
Return type
The characters of the CHAR, VARCHAR2, NCHAR, NVARCHAR2, or CLOB type are returned.
Examples
Execute the following statement:
SELECT UPPER('AaBbCcDd') upper FROM DUAL;
The following query result is returned:
+----------+
| UPPER |
+----------+
| AABBCCDD |
+----------+