TRIM from both sides : TRIM « Char Functions « Oracle PL / SQL






TRIM from both sides

SQL>
SQL>
SQL> SELECT TRIM (both ' ' from ' String with blanks ') FROM dual;

TRIM(BOTH''FROM'ST
------------------
String with blanks

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(TRAILING 'A' FROM 'ABCA') trail
5.TRIM: removes leading and trailing characters from a string
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