- 存储过程中按照传入参数删除数据:
CREATE OR REPLACE PROCEDURE UpdateByMonth(v_month IN NUMBER)
AS
v_count INTEGER :=0;
BEGIN
SELECT COUNT(1) INTO v_count FROM TEST WHERE MONTH = v_month;
IF v_count!=0 THEN
DELETE FROM TEST a WHERE a.month = v_month;
END IF;
COMMIT;
END;