Oracle UPPER function

Description

The Oracle UPPER() function returns a specified character expression in UPPERCASE letters.

Uses of Oracle UPPER Function

• Standardizing Text: Convert all characters in a string to uppercase for uniformity.


• Case-Insensitive Comparisons: Facilitate case-insensitive string comparisons by converting both strings to uppercase.


• Data Cleaning: Ensure consistent data entry by converting input to uppercase.


• Display Formatting: Prepare text for display where uppercase is required.

Syntax:

UPPER(string1)

Parameter:

Return Value Type

CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB

Note : For linguistic-sensitive uppercase, refer to NLS_UPPER.

Applies to

Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

Pictorial Presentation

Examples: Oracle UPPER function

The following example returns each employee's last name in uppercase:

SELECT UPPER(last_name) "Uppercase"
FROM employees;

Sample Output:

 Uppercase
----------------
ABEL
ANDE
ATKINSON
AUSTIN
BAER
BAIDA
BANDA
BATES
. . .

Previous: TRIM
Next: ASCII