TRIM(TRAILING 'A' FROM 'ABCA') trail

 
SQL>
SQL> SELECT
  2     TRIM('A' FROM 'ABCA')     both,
  3     TRIM(LEADING  'A' FROM 'ABCA')     lead,
  4     TRIM(TRAILING 'A' FROM 'ABCA')     trail,
  5     TRIM(' ABC ')      blank
  6  FROM dual;

BO LEA TRA BLA
-- --- --- ---
BC BCA ABC ABC

SQL>

Related examples in the same category

1.	Simple demo for TRIM function: removes all specified characters either from the beginning or the ending of a string
2.	TRAILING: trim from the end of a string
3.	LEADING: trim from the beginning of a string
4.	TRIM: removes leading and trailing characters from a string
5.	TRIM from both sides
6.	Characters rather than spaces are trimmed
7.	Nesting TRIM function
8.	TRIM Leading and Trailing Zeroes
9.	Trim space from a string
10.	Trim trailing space from a string

TRIM(TRAILING 'A' FROM 'ABCA') trail : TRIM « Char Functions « Oracle PL / SQL

Related examples in the same category