{"id":109,"date":"2017-03-25T11:08:01","date_gmt":"2017-03-25T02:08:01","guid":{"rendered":"http:\/\/skyit.biz\/?p=109"},"modified":"2017-03-25T11:08:01","modified_gmt":"2017-03-25T02:08:01","slug":"if%e6%96%87%e3%80%80plsql","status":"publish","type":"post","link":"https:\/\/skyit.biz\/?p=109","title":{"rendered":"IF\u6587\u3000pl\/sql"},"content":{"rendered":"<p>DECLARE<br \/>\nvNum NUMBER := 10;<br \/>\nvMsg VARCHAR2(255);<br \/>\nBEGIN<br \/>\n&#8212; \u6761\u4ef6\u306f\u30a4\u30b3\u30fc\u30eb\uff11\u3064\u3067\u8a55\u4fa1\u3059\u308b\u3002<br \/>\n&#8212; IF \uff5e THEN \u307e\u3067\u306e\u6587\u672b\u306e\u30bb\u30df\u30b3\u30ed\u30f3(;)\u306f\u4e0d\u8981<br \/>\nIF (vNum = 1) THEN<br \/>\nvMsg := &#8216;\u6570\u5024\u306f\uff11\u3067\u3059&#8217;;<\/p>\n<p>&#8212; ELSE IF \u3067\u306f\u306a\u304f ELSIF \u3068\u66f8\u304f (\u203b ELSEIF \u3067\u306f\u306a\u3044)<br \/>\nELSIF (vNum = 5) THEN<br \/>\nvMsg := &#8216;\u6570\u5024\u306f\uff15\u3067\u3059&#8217;;<\/p>\n<p>&#8212; ELSE \u306e\u5834\u5408\u306b\u306f THEN \u3092\u66f8\u3044\u3066\u306f\u3044\u3051\u306a\u3044<br \/>\nELSE<br \/>\nvMsg := &#8216;\u6570\u5024\u306f\uff11\u3067\u3082\uff15\u3067\u3082\u3042\u308a\u307e\u305b\u3093&#8217;;<\/p>\n<p>&#8212; IF \u6587\u306e\u7d42\u308f\u308a\u306f END IF ;<br \/>\nEND IF;<\/p>\n<p>DBMS_OUTPUT.PUT_LINE(vMsg);<br \/>\nEND;<br \/>\n\/<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DECLARE vNum NUMBER := 10; vMsg VARCHAR2(255); BEGIN &#8212; \u6761\u4ef6\u306f\u30a4\u30b3\u30fc\u30eb\uff11\u3064\u3067\u8a55\u4fa1\u3059\u308b\u3002 &#8212; IF \uff5e THEN \u307e\u3067\u306e\u6587\u672b\u306e\u30bb\u30df\u30b3\u30ed\u30f3(;)\u306f [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,13],"tags":[],"class_list":{"0":"post-109","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-oracle","7":"category-plsql"},"_links":{"self":[{"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/posts\/109","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=109"}],"version-history":[{"count":1,"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/posts\/109\/revisions"}],"predecessor-version":[{"id":110,"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/posts\/109\/revisions\/110"}],"wp:attachment":[{"href":"https:\/\/skyit.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}