{"id":2783,"date":"2013-06-03T20:32:37","date_gmt":"2013-06-03T11:32:37","guid":{"rendered":"http:\/\/pchero21.com\/?p=2783"},"modified":"2013-06-03T20:32:37","modified_gmt":"2013-06-03T11:32:37","slug":"oracle-procedure-print-%ec%b0%8d%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/pchero21.com\/?p=2783","title":{"rendered":"Oracle Procedure Print \ucc0d\uae30&#8230;"},"content":{"rendered":"<p>Oracle Procedure \ub97c \ud14c\uc2a4\ud2b8\ud560 \ub54c, \ub0b4\ubd80 \ubcc0\uc218\ub4e4\uc5d0 \ud560\ub2f9\ub41c \uac12\uc744 \ud655\uc778\ud574\uc57c\ud560 \ub54c\uac00 \uc788\ub2e4.<\/p>\n<p>\uc774\ub7f4 \ub54c, \ub2e4\uc74c\uc758 \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uba74 \ud655\uc778\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n<blockquote>\n<pre>SQL> set serveroutput on format wrap\nSQL> declare\n  2      x varchar2(30) := 'My name is neo.';\n  3  begin\n  4      dbms_output.enable(1000000);\n  5      dbms_output.put_line ('The value of variable \"x\" is: ['||x||']');\n  6* end;\nSQL> \n\/The value of variable \"x\" is: [My name is neo.]<\/pre>\n<\/blockquote>\n<pre>\ucc38\uc870 : www.dbforums.com\/oracle\/1644155-how-print-value-variable-used-oracle-procedure.html\n\ucc38\uc870 : http:\/\/stackoverflow.com\/questions\/9519510\/how-to-printf-in-oracle-stored-procedure-for-debugging-purposes\n\ucc38\uc870 : http:\/\/dscythe.tistory.com\/69\n\ucc38\uc870 : http:\/\/stackoverflow.com\/questions\/7352366\/oracle-stored-procedure-printing-varchar2-output-variable\n\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Oracle Procedure \ub97c \ud14c\uc2a4\ud2b8\ud560 \ub54c, \ub0b4\ubd80 \ubcc0\uc218\ub4e4\uc5d0 \ud560\ub2f9\ub41c \uac12\uc744 \ud655\uc778\ud574\uc57c\ud560 \ub54c\uac00 \uc788\ub2e4. \uc774\ub7f4 \ub54c, \ub2e4\uc74c\uc758 \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uba74 \ud655\uc778\uc774 \uac00\ub2a5\ud558\ub2e4. SQL> set serveroutput on format wrap SQL> declare 2 x varchar2(30) := &#8216;My name is neo.&#8217;; 3 begin 4 dbms_output.enable(1000000); 5 &hellip; <a href=\"http:\/\/pchero21.com\/?p=2783\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[17],"tags":[],"_links":{"self":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/posts\/2783"}],"collection":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2783"}],"version-history":[{"count":0,"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/posts\/2783\/revisions"}],"wp:attachment":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2783"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2783"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2783"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}