1、创建测试表,
create table test_huiche(id varchar2(20), value varchar2(20));
2、插入测试数据,部分值含回车换行符;
insert into test_huiche values(1, 'ab
c');
insert into test_huiche values(2,'ed');
insert into test_huiche values(3,'ffg');
insert into test_huiche values(4,'hj
k');
commit;
3、查询表中全量数据,可以发现部分值含回车换行符;select t.*, rowid from test_huiche t;
4、编写语句,去掉数据后的回车换行符;
select t.id, replace(replace(t.value,chr(9),''),chr(10),'') as value from test_huiche t;