{"id":113,"date":"2017-03-25T11:32:08","date_gmt":"2017-03-25T02:32:08","guid":{"rendered":"http:\/\/skyit.biz\/?p=113"},"modified":"2017-03-25T11:50:32","modified_gmt":"2017-03-25T02:50:32","slug":"%e3%82%b9%e3%83%88%e3%82%a2%e3%83%89%e3%83%97%e3%83%ad%e3%82%b7%e3%83%bc%e3%82%b8%e3%83%a3%e3%81%ae%e4%bd%9c%e6%88%901","status":"publish","type":"post","link":"https:\/\/skyit.biz\/?p=113","title":{"rendered":"\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306e\u4f5c\u62101"},"content":{"rendered":"

 <\/p>\n

RIVUS\u30e6\u30fc\u30b6\u3067Function\u3092\u4f5c\u6210\u3057\u305f\u3002<\/p>\n

CREATE OR REPLACE FUNCTION RIVUS.PRODUCT
\n(
\nP_NUM1 IN NUMBER,
\nP_NUM2 IN NUMBER
\n)
\nRETURN NUMBER
\nIS
\nvSum NUMBER(2) DEFAULT 0;
\n— vSum NUMBER(2) := 0;
\nBEGIN
\nFOR i IN 1..P_NUM2
\nLOOP
\nvSum := vSum + P_NUM1;
\nEND LOOP;
\nRETURN vSum ;
\nEND;
\n\/<\/p>\n

 <\/p>\n

\u5b9f\u884c\u30b3\u30de\u30f3\u30c9<\/p>\n

SQL> select rivus.product(5,6) from dual;<\/p>\n

 <\/p>\n

\u5b9f\u884c\u7d50\u679c<\/p>\n

RIVUS.PRODUCT(5,6)
\n——————
\n30<\/p>\n","protected":false},"excerpt":{"rendered":"

  RIVUS\u30e6\u30fc\u30b6\u3067Function\u3092\u4f5c\u6210\u3057\u305f\u3002 CREATE OR REPLACE FUNCTION RIVUS.PRODUCT ( P_NUM1 IN NUMBER, P_NUM2 IN NUMBER ) […]<\/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-113","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\/113","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=113"}],"version-history":[{"count":2,"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/posts\/113\/revisions"}],"predecessor-version":[{"id":118,"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/posts\/113\/revisions\/118"}],"wp:attachment":[{"href":"https:\/\/skyit.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=113"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}