Oracle正则表达式使用介绍

select * from organization o where o.orgname like '%海王星辰%春%';
select * from organization o where regexp_like(o.orgname,'(海王星辰|春)+')select * from organization o where o.orgname li