{"blog_title":"HTN20190109\u306e\u65e5\u8a18","published":"2019-04-09 00:05:32","type":"rich","width":"100%","height":"190","provider_url":"https://hatena.blog","author_name":"HTN20190109","blog_url":"https://htn20190109.hatenablog.com/","title":"\u30eb\u30fc\u30d7\u51e6\u7406","url":"https://htn20190109.hatenablog.com/entry/2019/04/09/000532","version":"1.0","provider_name":"Hatena Blog","description":"Oracle set serveroutput on size 1000000 declarer_tab2 tab99%rowtype;beginfor i in 1..1000 loop select * into r_tab2 from tab99 where rownum = 1; insert into tab1 values(r_tab2.col1); commit;end loop; exception when others then dbms_output.put_line(SQLCODE); dbms_output.put_line(SQLERRM);end;/ MySQL \u2026","author_url":"https://blog.hatena.ne.jp/HTN20190109/","image_url":null,"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2019%2F04%2F09%2F000532\" title=\"\u30eb\u30fc\u30d7\u51e6\u7406 - HTN20190109\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","categories":["DB"]}