Advanced Search

Return to Snippet

Revision: 71057
at December 19, 2016 05:23 by bbrumm
Initial Code 
SELECT LTRIM('    Complete IT Professional') AS LTRIM_EXAMPLE FROM DUAL;

SELECT LTRIM('___Complete IT Professional', '_') AS LTRIM_EXAMPLE FROM DUAL;

SELECT LTRIM('; ; ; ; ; Complete IT Professional', ' ; ') AS LTRIM_EXAMPLE FROM DUAL;

SELECT country, LTRIM(country, 'U') AS LTRIM_EXAMPLE FROM customers;

SELECT full_address, LTRIM(full_address, '1') AS LTRIM_EXAMPLE FROM customers;

SELECT LTRIM('000Complete IT Professional', 0) AS LTRIM_EXAMPLE FROM DUAL;

SELECT LTRIM(RTRIM('___Complete IT Professional__', '_'), '_') AS LTRIM_EXAMPLE FROM DUAL;

SELECT LTRIM('ééComplete IT Professional', 'é') AS LTRIM_EXAMPLE FROM DUAL;
Initial URL 
http://www.databasestar.com/oracle-ltrim/
Initial Description 
A few examples of the Oracle LTRIM function.
Initial Title 
Oracle LTRIM Function
Initial Tags 
sql, Oracle
Initial Language 
SQL