Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

11.18   How to use RTRIM( )

function

When we need to remove right most unwanted or to be eliminated characters on the column we need to use the following syntax:

Syntax:  select rtrim (', aaa, bbb,',',') as result from dual;

Result:

Result

- - - - -

,aaa,bbb

11.19   How to use TRIM( )

function

When we need to remove both sides right and left most unwanted or to be eliminated characters on the column we need to use the following syntax:

Syntax:   select trim(',' from ',aaa,bbb,') as result from dual;

Result :

Result

- - - - -