Posted By

bbrumm on 12/15/16

Tagged

sql
Oracle

Versions (?)

Last Edited at 12/15/16 04:56am

Statistics

Viewed 717 times

Favorited by 0 user(s)

Related snippets

Oracle RTRIM Function

/ Published in: SQL

A few examples of the Oracle RTRIM function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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;