Character String Functions Oracle PLSQL Tutorial

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