create or replace function F_GET_StringPosition(i_scantype in varchar2,--逗號隔開的字符串
i_cnc varchar2)--其中的一個字符
return number is
Result number;
/*
*根據scantype 獲取cnc詳情信息位置
**/
begin
select RN
into Result
from (SELECT REGEXP_SUBSTR(i_scantype, '[^,]+', 1, LEVEL) as RR,
rownum rn
FROM DUAL
CONNECT BY REGEXP_SUBSTR(i_scantype, '[^,]+', 1, LEVEL) IS NOT NULL
order by 1)
where RR = i_cnc;
return(Result);
end F_GET_StringPosition;
oracle 逗号隔开字符串 定位某个字符在第几位
最新推荐文章于 2023-03-27 15:14:22 发布