Oracle 判断字段是否匹配两个字符串嘛，正则表达式regexp_like

[赵小花啦啦啦啦]

查找出text字段中包含a和b的数据;
a='kmm.hwhdiwidj_sjdhjs_dsd';
b='whdh_dwud'
这种用正则表达式怎么实现呢

[leizhanzi]

select text from tb where regexp_like(text,'kmm.hwhdiwidj_sjdhjs_dsd|whdh_dwud');