FUNCTION F_GETSUBSTR
(
V_STR VARCHAR2
)
RETURN VARCHAR2
IS
V_RTNSTR VARCHAR2(100);
BEGIN
SELECT SUBSTR(V_STR,INSTR(V_STR,'-')+1) INTO V_RTNSTR FROM DUAL;
RETURN V_RTNSTR;
END;
Oracle返回截取字符串
最新推荐文章于 2022-03-29 17:31:10 发布