Character String Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Character String Functions
  4. Nested trim
SQL>  SELECT TRIM(TRIM (both 'z'  from 'zzzzz I am asleep zzzzzz'))  FROM dual
  2  ;
TRIM(TRIM(B
-----------
I am asleep
SQL>