Characters rather than spaces are trimmed
SQL> SQL> -- Characters rather than spaces are trimmed SQL> SQL> SQL> SQL> SELECT TRIM('F' from 'Frogs prefer deep water') FROM dual; TRIM('F'FROM'FROGSPREF ---------------------- rogs prefer deep water SQL>