Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

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>