17,377
社区成员
发帖
与我相关
我的任务
分享
select * from WIP_SCHEDULE where doc_id like '%6\_%' escape '\';
with myOrders as (
select 1 as id,'21' as oreder_s from dual
(1)select * from myOrders where oreder_s like '%1%'
(2)select * from myOrders where oreder_s like '%1_%'
)
对于(1)是可以查出结果的,但是对于(2)则查不出结果