全部博文
-
编辑 删除
Oracle带参数的游标使用
CREATE OR REPLACE PROCEDURE PC_PERF_SUPP_TMP(SDATE in varchar2, EDATE in varchar2, GNAME in varchar2) IS V_FN_OBJECTID varchar2(100); V_COLTIME varchar2(30); V_IFINDISCARDS NUMBER; V_IFINNUCASTPKTS number; V_IFINOCTETS number; V_IFINSPEED number; V_IFINSPEED_MAX number; V_IFINSPEED_MIN number; V_IFINSPEED_AVG number; V_IFINUCASTPKTS number; V_IFINUTIL number; V_IFINUTIL_MAX number; V_IFINUTIL_MIN number; V_IFINUTIL_AVG number; V_IFOPERSTATUS number; V_IFOUTDISCARDS number; V_IFOUTNUCASTPKTS
