Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

TRIM from both sides

SQL> SQL> SQL> SELECT TRIM (both ' ' from ' String with blanks ') FROM dual; TRIM(BOTH''FROM'ST ------------------ String with blanks SQL>