Advanced Search

Return to Snippet

Revision: 71052
at December 15, 2016 04:56 by bbrumm
Initial Code 
SELECT RTRIM('Complete IT Professional   ') AS RTRIM_EXAMPLE FROM DUAL;

SELECT RTRIM('Complete IT Professional___', '_') AS RTRIM_EXAMPLE FROM DUAL;

SELECT RTRIM('Complete IT Professional; ; ; ; ; ', ' ; ') AS RTRIM_EXAMPLE FROM DUAL;

SELECT country, RTRIM(country, 'A') AS RTRIM_EXAMPLE FROM customers;

SELECT full_address, RTRIM(full_address, 'et') AS RTRIM_EXAMPLE FROM customers;

SELECT RTRIM('Complete IT Professional00', 0) AS RTRIM_EXAMPLE FROM DUAL;

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

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