SELECT REGEXP_REPLACE(NAME, '( ){1,}', '')
FROM P_TB_MBR
WHERE INSTR(NAME, ' ') > 0;




http://karria.tistory.com/9