本人是个菜鸟,现在想实现通过select语句查询处多个值作为REGEXP_LIKE的表达式,实现like多个条件(多条件的模糊查询)。请高手指教。
select * from tb_org_unitrelation t where REGEXP_LIKE(t.c_path_code,select REPLACE(to_char(wm_concat ( ul.c_path_code)),',','|')
from tb_org_unitrelation ul, tb_org_orgunit o
where ul.c_org_hid = o.c_hid
and o.c_hid in (
select replace(regexp_substr('79c500fbaadf4476b79245e16039cd01,ef18d980cb1a40db89af4397c857ab14,60108a6650b74e47bbb7ae4a1651cef1', '[^,]+', 1, level), ',', ' ') c2
from dual
connect by level <= length('79c500fbaadf4476b79245e16039cd01,ef18d980cb1a40db89af4397c857ab14,60108a6650b74e47bbb7ae4a1651cef1') - length(replace('79c500fbaadf4476b79245e16039cd01,ef18d980cb1a40db89af4397c857ab14,60108a6650b74e47bbb7ae4a1651cef1', ',', '')) + 1
)
and to_date('2018-09-30','yyyy-mm-dd') between ul.c_begin_date and ul.c_end_date
and to_date('2018-09-30','yyyy-mm-dd') between o.c_begin_date and o.c_end_date
and o.c_status = '1'
and ul.c_status = 1
and ul.c_dim_hid = '65ca64ab44274d789f8e958abbddc406')