w3resource

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

Oracle Upper function 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



Share this Tutorial / Exercise on : Facebook and Twitter