Character String Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Character String Functions
  4. TRIM (both from String with blanks )
SQL>  SELECT TRIM (both ' '  from ' String with blanks ')  FROM dual;
TRIM(BOTH''FROM'ST
------------------
String with blanks
SQL>