/*条件控制：if语句*/
<<if_then>>
DECLARE
v_id NUMBER := &v_id;
BEGIN
IF v_id > id_test01.CURRVAL
THEN
INSERT INTO test01 (id, name, age) VALUES (id_test01.NEXTVAL, '悟空', id_test01.CURRVAL + 10);
COMMIT;
END IF;
END if_then;
/*条件控制：if_then_else语句*/
<<if_then_else>>
DECLARE
v_id NUMBER := &v_id;
BEGIN
IF v_id = id_test01.CURRVAL
THEN
UPDATE test01 SET name = 'aa' WHERE id = v_id;
ELSE
DELETE FROM test01 WHERE id > v_id;
END IF;
END if_then_else;
/*条件控制：ELSIF 语句*/
<<elsif_a>>
DECLARE
v_id NUMBER := &v_id;
BEGIN
IF v_id < id_test01.CURRVAL
THEN
INSERT INTO test01 (id, name, age) VALUES (v_id, 'aa', v_id);
ELSIF v_id = id_test01.CURRVAL
THEN
INSERT INTO test01 (id, name, age) VALUES (v_id, 'bb', v_id);
ELSE
INSERT INTO test01 (id, name, age) VALUES (id_test01.NEXTVAL, 'cc', v_id);
END IF;
END elsif_a;
--if 也可以做嵌套
本公众号是个人学习工作笔记，希望大家发现问题能及时和我本人沟通，希望你与我共同成长。个人微信zgjt12306。
欢迎关注“自学Oracle”
