Nested trim : TRIM « Character String Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Character String Functions
  3. TRIM
SQL> SELECT TRIM(TRIM (both 'z' from 'zzzzz I am asleep zzzzzz')) FROM dual
  2  ;

TRIM(TRIM(B
-----------
I am asleep

SQL>








11.15.TRIM
11.15.1.The TRIM Function
11.15.2.TRIM (both ' ' from ' String with blanks ')
11.15.3.Characters rather than spaces are trimmed
11.15.4.TRIM(leading 'F' from 'FABCDEF')
11.15.5.TRIM(trailing 'r' from 'Real water')
11.15.6.TRIM from both sides
11.15.7.Nested trim
11.15.8.TRIM Leading and Trailing Zeroes
11.15.9.Triming leading 'H' from employee last name
11.15.10.match trimmed string