問題：需要將A表中的B欄位里包含下列內容的值全部刪掉
需要洗掉的內容：物件契約的發送日為2018年05月01日。/證券番號
其中證券番號為可變的11位字符
uj5u.com熱心網友回復：
給一下測驗資料，和你的想要的結果，資料要有代表性。uj5u.com熱心網友回復：
replace(b,'物件契約的發送日為2018年05月01日。/a^z','')uj5u.com熱心網友回復：
把測驗資料給出來哦uj5u.com熱心網友回復：
with tab1 as (
select 'aabbccddeeff' src from dual union all
select 'aabbccddeeffgggggggggggggg' from dual
),
tab2 as (
select 'bb' str from dual union all
select 'ee' from dual union all
select 'ff' from dual
)
, tab3 as (
select src, result_ from tab1 t1, tab2 t2
where 1 = 1
and instr(t1.src, t2.str) > 0
model
partition by (src)
dimension by (row_number() over(partition by t1.src order by t1.src) rn)
measures (str, src result_)
rules(
result_[rn] = regexp_replace(nvl(result_[cv() - 1], result_[cv()]), str[cv()])
)
)
, tab4 as (
select src, row_number() over(partition by t1.src order by length(result_)) rn, result_ from tab3 t1
)
select * from tab4 t1
where t1.rn = 1
;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/65081.html
標籤：開發
上一篇：Oracle判斷陳述句寫法求助
下一篇：Oracle查詢問題