plsql中正则及decode中使用

碰到个小问题 记录下，有用sql中的正则表达式

看看吧

select xmo_dw.url_decode(domain) as domain, substring(xmo_dw.url_decode(domain) 

from '^https?:\/\/(.*?)\/.*?') from xmo_dw.rtb_datas where searchengine_id

 in (select id from xmo_dw.searchengines where campaign_id=14039) and viewed_at_i=20151122 limit 5;