让程序DO-NOTHING

–如下面这段代码。
DECLARE
V_TEMPVAR NUMBER := 7;
BEGIN
IF V_TEMPVAR < 5 THEN
INSERT INTO TEMP_TABLE (CHAR_COL) VALUES ('TOO SMALL');
ELSIF V_TEMPVAR < 10 THEN
INSERT INTO TEMP_TABLE (CHAR_COL) VALUES ('JUST RIGHT');
ELSE
NULL; —DOO NOTHING..–这里让程序除了以上几种情况后,DO NOTHING~
END IF;
END;

8 thoughts on “让程序DO-NOTHING”

Comments are closed.