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