Oracle关于查询语句条件里面有换行的问题。各位大侠帮帮忙
SELECT *
FROM wms_goods_info t
WHERE t.goods_name='%DDGKMM
11%'
条件里面这个DDGKMM
11是换了行的。我不管怎么行SQL语句也查询不出数据库里面的结果。各位帮我看看，万分感谢 oracle
[解决办法]
SELECT *
FROM wms_goods_info t
WHERE t.goods_name like '%DDGKMM
11%'
[解决办法]
select * from fky where aa like '%wor
ld%';
select * from fky where aa like '%wor%ld%';
select * from fky where aa like '%wor'
[解决办法]
chr(10)
[解决办法]
'ld%';
select * from fky where aa like '%wor'
[解决办法]
chr(13)
[解决办法]
chr(10)
[解决办法]
'ld%';


自己选一个可用的吧