ORACLE - String Functions : rtrim

the rtrim function removes all specified characters from the right-hand side of a string.

The syntax is:

rtrim( string1, [ trim_string ] )

string1 is the string to trim the characters from the right-hand side.
trim_string is the string that will be removed from the right-hand side of string1. If this parameter is omitted, the rtrim function will remove all trailing spaces from string1.

For example:

rtrim('hola '); would return 'hola'
rtrim('hola ', ' '); would return 'hola'
rtrim('paris000', '0'); would return 'paris'

rtrim('332312paris1233213', '123'); would return '332312paris' (removes the individual occurrences of '1', '2', and '3')

No hay comentarios: