首页 » ORACLE 9i-23ai » 让程序DO-NOTHING

让程序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条评论(Rss)评论关闭。

  1. happyday67 | #1
    2011-09-21 at 03:40

    Excellent job with your entry. A lot people may look at it that way for sure and honestly validate with the point.