?

過濾指定的字符串,一字符串有重復的數據內容,所以需要去掉重復的內容,subst()截取 起止下標;instr()獲取終止下標位置 例如:substr(p.address, 0, instr(p.address, '-', 1, 1)-1) );

?

case when length(substr(p.address, 0, instr(p.address, '-', 1, 1)-1) )= 13
then substr(substr(p.address, 0, instr(p.address, '-', 1, 1)-1),0,8)||substr(p.address, instr(p.address, '-', 1, 1), length(p.address))
when length(substr(p.address, 0, instr(p.address, '-', 1, 1)-1) )= 11
then substr(substr(p.address, 0, instr(p.address, '-', 1, 1)-1),0,7)||substr(p.address, instr(p.address, '-', 1, 1), length(p.address))
when nvl(length(substr(p.address, 0, instr(p.address, '-', 1, 1)-1) ),0) != 7
and nvl(length(substr(p.address, 0, instr(p.address, '-', 1, 1)-1) ),0) != 8
and length(address) =11
then substr(address,0,7)
when nvl( length(substr(p.address, 0, instr(p.address, '-', 1, 1)-1) ),0) != 8
and nvl(length(substr(p.address, 0, instr(p.address, '-', 1, 1)-1) ),0) != 7
and length(address) =13
then substr(address,0,8)
else address end sub

?

轉載于:https://www.cnblogs.com/dashanruolong/p/6774773.html

總結

以上是生活随笔為你收集整理的oracle 截取字指定的字符串的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。