oracle实现like多关键字查询:
查询脚本:
select F_CREATORUSERID
from atabletemplate tt
where 1 = 1
and REGEXP_LIKE(tt.F_CREATORUSERID, '18C21-03050|6005119')
执行结果:
2023-08-28 17:28:52
oracle实现like多关键字查询:
查询脚本:
select F_CREATORUSERID
from atabletemplate tt
where 1 = 1
and REGEXP_LIKE(tt.F_CREATORUSERID, '18C21-03050|6005119')
执行结果: