본문 바로가기
ㄱWORK, ETC/Oracle

TAB 공백 제거하기

by YuyU유유 2023. 4. 26.
728x90
반응형

SELECT REGEXP_REPLACE('변경필드','(^[[:space:]]*|[[:space:]]*$)')

FROM DUAL;

SELECT 'TAB공백제거하기         ' sample_text
  ,regexp_replace('TAB공백제거하기         ','(^[[:space:]]*|[[:space:]]*$)') ch_text
FROM   dual;

 

 

728x90
반응형