求大佬幫幫忙
uj5u.com熱心網友回復：
select regexp_substr(remark, '[^(國家稅務局)]+[^(稅務局)]', 1, 1),
regexp_replace(remark, '國家稅務局|稅務局'),
replace(replace(remark, '國家稅務局'), '稅務局')
from (select '國家稅務局湖北稅務局' as remark
from dual
union
select '國家稅務局上海市陸家嘴稅務局' as remark
from dual
union
select '國家稅務局杭州市稅務稅務局' as remark
from dual)
uj5u.com熱心網友回復：
select regexp_substr(remark, '[^(國家稅務局)]+[^(稅務局)]+', 1, 1),
uj5u.com熱心網友回復：
with tmp as( select '國家稅務局湖北稅務局' as remark
from dual
union
select '國家稅務局廣西壯族自治區稅務局' as remark
from dual
union
select '國家稅務局黑龍江省稅務稅務局' as remark
from dual)
select regexp_substr(t.remark, '[ ^(國家稅務局)]+[^(稅務局)]+', 1, 1)
from tmp t;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/11568.html
標籤：高級技術