SELECT * FROM ALL_SOURCE where TYPE=‘PROCEDURE’ AND TEXT LIKE ‘%’||upper(‘过期’)||’%’
SELECT DISTINCT NAME FROM user_source WHERE TYPE = ‘PROCEDURE’ AND upper(text) LIKE ‘%PICC_ORDER_QUERY_REPORT%’;
SELECT * FROM ALL_SOURCE where TYPE=‘PROCEDURE’ AND TEXT LIKE ‘%’||upper(‘过期’)||’%’
SELECT DISTINCT NAME FROM user_source WHERE TYPE = ‘PROCEDURE’ AND upper(text) LIKE ‘%PICC_ORDER_QUERY_REPORT%’;