Character String Functions Oracle PLSQL Tutorial

SQL>  SELECT TRIM(trailing 'r'  from 'Real water')FROM dual;
TRIM(TRAI
---------
Real wate
SQL>