Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

TRIM(trailing r from Real water)

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