Char Functions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Char Functions
  4. 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>