SQL> select replace(a || chr(9) || b || chr(9) || c, chr(9)) as str from dual;

STR
---
abc

SQL>
via
  • ORACLE/オラクルSQLリファレンス(REPLACE/TRANSLATE)