Oracle UPPER function
Description
The Oracle UPPER() function returns a specified character expression in UPPERCASE letters.
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 . . .
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join