Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

Nested trim

SQL>  SELECT TRIM(TRIM (both 'z'  from 'zzzzz I am asleep zzzzzz'))  FROM dual   2  ; TRIM(TRIM(B ----------- I am asleep SQL>