Convert a String to Uppercase in Oracle

Convert a String to Uppercase in Oracle

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • SQL
  • 1 min read

To convert a string to uppercase, use the upper() function in Oracle. Below are the syntax and examples:

UPPER Function Syntax

upper(char)

UPPER Function Examples

The following SQL query converts a string to uppercase using the upper() function:

select upper('oracle') from dual;

Output:

ORACLE

Using UPPER Function in PL/SQL Program

Below PL/SQL code demonstrates, how to convert a string to uppercase in the program unit:

Declare
  v_string varchar2(100) := 'oracle';
begin
  v_string := upper(v_string);
  dbms_output.put_Line(v_string);
end;

Output

ORACLE

See also: