PLSQL | LTRIM Function

The PLSQL LTRIM function is used for removing all specified characters from the left-hand side of a string. The PLSQL LTRIM function accepts two parameters which are input_string and trim_string.

• If the user does not specify trim_string, it defaults to a single blank.
• If char is a character literal, then you must enclose it in single quotes.

Oracle Database begins scanning char from its first character and removes all characters that appear in trim_string until reaching a character not in trim_string and then returns the result.

Syntax:

LTRIM( input_string [, trim_string] )

Parameters Used:

• input_string – It is used to specify the string whose characters need to be trimmed from the left hand side.
• trim_string – It is an optional parameter which is used to specify the string that will be removed from the left-hand side of string1. If this parameter is omitted, the LTRIM function removes all leading spaces from input_string.

Supported Versions of Oracle/PLSQL:

1. Oracle 12c
2. Oracle 11g
3. Oracle 10g
4. Oracle 9i
5. Oracle 8i

Example-1:

DECLARE 
   Test_String string(25) := '    w3wiki';
   
BEGIN 
   dbms_output.put_line(LTRIM(Test_String)); 
   
END; 

Output:

w3wiki 

Example-2:

DECLARE 
   Test_String string(25) := '    w3wiki';
   
BEGIN 
   dbms_output.put_line(LTRIM(Test_String, ' ')); 
   
END; 

Output:

w3wiki 

Example-3:

DECLARE 
   Test_String string(25) := '123w3wiki';
   
BEGIN 
   dbms_output.put_line(LTRIM(Test_String, '123')); 
   
END; 

Output:

w3wiki 

Example-4:

DECLARE 
   Test_String string(25) := '123123w3wiki';
   
BEGIN 
   dbms_output.put_line(LTRIM(Test_String, '123')); 
   
END; 

Output:

w3wiki 

Example-5:

DECLARE 
   Test_String string(25) := '123Beginner123forBeginner';
   
BEGIN 
   dbms_output.put_line(LTRIM(Test_String, '123')); 
   
END; 

Output:

Beginner123forBeginner