{"version":"1.0","provider_name":"Hatena Blog","description":"\u6b63\u3057\u3044 SQL \u306a\u306f\u305a\u306a\u306e\u306b\u3001SQL*Plus \u3067\u5b9f\u884c\u3059\u308b\u3068\u3001SP2-0734 \u304c\u767a\u751f\u3059\u308b\u3002 SQL> @test.sql SP2-0734: unknown command beginning \"CASE WHEN ...\" - rest of line ignored. ... \u30a8\u30e9\u30fc\u306b\u306a\u3063\u3066\u3044\u308b\u7b87\u6240\u3092\u898b\u3066\u307f\u308b\u3068\u3001 END COL1, CASE WHEN \u7a7a\u884c\u3092\u524a\u9664\u3057\u3066\u3001 $ perl -i.org -ne '/^\\s*$/ or print' test.sql \u518d\u5b9f\u884c\u3057\u3066\u307f\u308b\u3068\u3001 SQL> @test.sql 1 rows selected \u304a\uff4b\uff01 \u3068\u3044\u3046\u308f\u3051\u3067\u539f\u56e0\u306f\u7a7a\u884c\u3060\u3063\u305f\u3002 \u3064\u307e\u308a\u2026","author_name":"yohei-a","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fyohei-a.hatenablog.jp%2Fentry%2F20100409%2F1270794963\" title=\"SP2-0734: unknown command beginning &quot;CASE WHEN ...&quot; - rest of line ignored. - ablog\" 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","categories":["Oracle"],"url":"https://yohei-a.hatenablog.jp/entry/20100409/1270794963","blog_url":"https://yohei-a.hatenablog.jp/","author_url":"https://blog.hatena.ne.jp/yohei-a/","blog_title":"ablog","type":"rich","published":"2010-04-09 15:36:03","height":"190","image_url":null,"width":"100%","title":"SP2-0734: unknown command beginning \"CASE WHEN ...\" - rest of line ignored."}