Oracle PL/SQL: String Functions: LTRIM - The ltrim function removes all specified characters from the left-hand side of a string.<br />

Quick Search:

Oracle PL/SQL: String Functions: LTRIM

Jump to:

Category: >> Oracle PL/SQL >> String Functions: LTRIM

<< last

next >>

Snippet Name: String Functions: LTRIM

Description: The ltrim function removes all specified characters from the left-hand side of a string.

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 10th, 2009

SELECT LTRIM('   milk') FROM dual; 
returns 'milk' 
 
SELECT LTRIM('   milk', ' ') FROM dual; 
returns 'milk' 
 
SELECT LTRIM('000123', '0') FROM dual; 
returns '123' 
 
SELECT LTRIM('123123milk'', '123') from dual; 
returns 'milk' 
 
select ltrim('123123milk123', '123') from dual; 
returns 'milk123'