개발/데이타베이스

oracle 문자열 line feed, carrage return 개행 문자 삭제

by 로그인시러 2017. 1. 16.

REPLACE(col_name, CHR(10), '')

REPLACE(col_name, CHR(13), '')

REPLACE(REPLACE(col_name, CHR(10), ''),CHR(13), '')

-------------------------------

Chr(13) = \r

Chr(10) = \n

Chr(13)Chr(10) = \r\n

뽕