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