摘要: https://www.cnblogs.com/shook/p/14344068.html 阅读全文
posted @ 2022-02-11 18:02 一只竹节虫 阅读(76) 评论(0) 推荐(0)
摘要: DECLARE v_job_exists INT;BEGIN SELECT COUNT(*) INTO v_job_exists FROM SYSJOB.SYSJOBS WHERE NAME = 'JOB_AUTO_SETTLE_RPT'; IF v_job_exists > 0 THEN CALL 阅读全文
posted @ 2022-02-11 11:28 一只竹节虫 阅读(188) 评论(0) 推荐(0)
摘要: 1.执行 CREATE OR REPLACE FUNCTION count_rows ( table_name IN varchar2, owner IN varchar2 := NULL)RETURN number AUTHID current_userASnum_rows number; stm 阅读全文
posted @ 2022-02-11 10:07 一只竹节虫 阅读(5662) 评论(0) 推荐(1)