Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

TRIM from both sides

SQL>  SELECT TRIM (both 'z'  from 'zzzzz I am asleep zzzzzz')  FROM dual; TRIM(BOTH'Z'F -------------  I am asleep SQL>