Oracle UPPER function

Last update on August 07 2024 06:25:41 (UTC/GMT +8 hours)

Description

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

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.

Syntax:

UPPER(string1)

Parameter:

Name	Description	Data Types
string1	The given character expression.	CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB

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