All Products
Search
Document Center

UPPER

Last Updated: Jun 18, 2021

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 |
+----------+