Posted By

bbrumm on 12/19/16

Tagged

sql
Oracle

Versions (?)

Last Edited at 12/19/16 05:23am

Statistics

Viewed 724 times

Favorited by 0 user(s)

Related snippets

Oracle LTRIM Function

/ Published in: SQL

A few examples of the Oracle LTRIM function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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;