원치않는 줄바꿈 없애기

select replace(fieldnm, chr(13)||chr(10), '') from table_name;