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