Simple demo for TRIM function: removes all specified characters either from the beginning or the ending of a string : TRIM « Char Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Char Functions
  3. TRIM

Simple demo for TRIM function: removes all specified characters either from the beginning or the ending of a string



SQL>
SQL> --For example, the following query removes the character "S" from a string:
SQL>
SQL> SELECT TRIM('S' FROM 'STEVENS') AS TRIM FROM Dual;

TRIM
-----
TEVEN

SQL>








Related examples in the same category

1.TRAILING: trim from the end of a string
2.LEADING: trim from the beginning of a string
3.TRIM(TRAILING 'A' FROM 'ABCA') trail
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