Oracle SQL Uppercase First Letter

Oracle SQL Uppercase First Letter

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

In Oracle, you can use the initcap() function to get the first letter in uppercase in SQL.

INITCAP() Syntax

initcap(string)

Change the first letter in uppercase using initcap() Examples

Capitalizing the first letter using the SQL query:

select initcap('oracle') from dual;

Output:

Oracle

Capitalizing the first letter of a string using PL/SQL program:

declare
   v_string varchar2(100) := 'oracle';
begin
   dbms_output.put_line(initcap(v_string));
end;

Output:

Oracle

See also: