Remove Spaces from Left in Oracle SQL

Remove Spaces from Left in Oracle SQL

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 remove spaces from the left side of a string use the ltrim() function in Oracle SQL.

LTRIM() Syntax

ltrim(string, set)

The LTRIM() function deletes all the characters in set from the left end of the string. If set is not given, a single blank will be used.

Removing Spaces from Left of a String in Oracle SQL

The following Oracle SQL query removes the spaces from the left side of the string:

select ltrim(' this is the string.')
    from dual

Output:

this is a string.

To remove the specific characters from the left side of a string, check the below example:

select ltrim('**this is the string.', '*') 
   from dual

Output:

this is the string.

Using LTRIM() Function in PL/SQL

The following PL/SQL program removes the space from the left side of a string and prints on the screen:

declare
v_string varchar2(100) := '   Oracle SQL';
begin
   dbms_output.put_line(ltrim(v_string));
end;

Output:

Oracle SQL

See also: