首页 » 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. Nigel Terry | #1
    2011-09-19 at 22:00

    Howdy, Could I export your page picture and utilize it on my blog page?

    • admin | #2
      2011-09-20 at 10:42

      yes

  2. Georgia Adams | #3
    2011-09-19 at 20:20

    This is the best web blog I have read.

  3. wenwens | #4
    2011-09-06 at 05:17

    I found your weblog on google and check several of the early posts and my seotons. Preserve up the excellent operate. I just extra up your RSS feed to my MSN News Reader. Seeking forward to reading via additional from you later on!

  4. Matilda | #5
    2011-06-23 at 07:02

    I wanted to spend a mitune to thank you for this.

  5. 匿名 | #6
    2011-05-24 at 13:38

    额。。看不懂。不做事不写就好了，为什么要NULL

    • Rope | #7
      2011-06-22 at 13:30

      With the bases loaded you srutck us out with that answer!

1 2

上一篇：

下一篇：