{"provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/YSuke/","blog_title":"YSuke\u306e\u8db3\u8de1","description":"SQL\u3092\u4f7f\u3063\u3066CSV\u30d5\u30a1\u30a4\u30eb\u3092\u51fa\u529b\u3059\u308b\u30c4\u30fc\u30eb \u53ef\u5909\u9577CSV \u5404\u30c7\u30fc\u30bf\u3092\u300c\"\u300d\u3067\u304f\u304f\u308b\u5834\u5408\u3002 spool variable.csvset pages 0 set head off set feed off set termout off lines xxx *1 trims onselect '\"'||col1||'\",'|| '\"'||col2||'\",'|| '\"'||col100||'\"' from target;set termout onspool off \u56fa\u5b9a\u9577CSV lpad, rpad\u95a2\u6570\u3067\u30c7\u30fc\u30bf\u9577\u5206\u3092\u88dc\u3046\u3002NULL\u306e\u5834\u5408\u306f\u30c7\u30fc\u30bf\u9577\u5206\u306e\u7a7a\u767d\u3067\u51fa\u529b\u3002 spool fix.csvse\u2026","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fysuke.hatenadiary.org%2Fentry%2F20090811%2F1249940325\" title=\"Oracle sql*plus\u3067CSV\u51fa\u529b(1) - YSuke\u306e\u8db3\u8de1\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_url":"https://hatena.blog","title":"Oracle sql*plus\u3067CSV\u51fa\u529b(1)","author_name":"YSuke","width":"100%","published":"2009-08-11 06:38:45","version":"1.0","blog_url":"https://ysuke.hatenadiary.org/","type":"rich","height":"190","categories":["Oracle"],"url":"https://ysuke.hatenadiary.org/entry/20090811/1249940325","image_url":null}