摘要: CREATE OR REPLACE FUNCTION fun_pinym(prm_name IN VARCHAR2) RETURN VARCHAR2 IS v_compare VARCHAR2(100); v_return VARCHAR2(4000);BEGIN DECLARE FUNCTION 阅读全文
posted @ 2020-09-16 16:14 绿水青山777 阅读(206) 评论(0) 推荐(0) 编辑
摘要: select lbid ,SUBSTR(lbid, INSTR(lbid, ';', -1, 2) + 1, INSTR(lbid, ';', -1) - 1 - INSTR(lbid, ';', -1, 2)),REPLACE(SUBSTR(lbid, INSTR(lbid, ';', -1, 2 阅读全文
posted @ 2020-09-16 16:11 绿水青山777 阅读(552) 评论(0) 推荐(0) 编辑