-- 3 判断语句
-- IF 比较式 THEN BEGIN END; END IF;
CREATE OR REPLACE PROCEDURE test(x IN NUMBER)
IS
BEGIN
IF x > 0
THEN
BEGIN
x := 0 - x;
END;
END IF;
IF x = 0
THEN
BEGIN
x := 1;
END;
END IF;
END test;
运行结果:
[2017-03-21 15:48:19] [99999][17110] Warning: 执行完毕, 但带有警告
[2017-03-21 15:48:19] completed in 8ms