{"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.shigemk2.com%2Fentry%2Fsql_puzzle_1\" title=\"2018 SQL Puzzle 1 - by shigemk2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","width":"100%","type":"rich","published":"2018-01-13 10:49:08","version":"1.0","provider_url":"https://hatena.blog","author_name":"shigemk2","image_url":"https://images-fe.ssl-images-amazon.com/images/I/51AysaMiZwL._SL160_.jpg","provider_name":"Hatena Blog","height":"190","title":"2018 SQL Puzzle 1","categories":["Oracle"],"url":"https://www.shigemk2.com/entry/sql_puzzle_1","blog_title":"by shigemk2","author_url":"https://blog.hatena.ne.jp/shigemk2/","description":"SQL\u30d1\u30ba\u30eb \u7b2c2\u7248~\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u304c\u5909\u308f\u308b\u66f8\u304d\u65b9/\u8003\u3048\u65b9\u4f5c\u8005: \u30b8\u30e7\u30fc\u30fb\u30bb\u30eb\u30b3,Joe Celko,\u30df\u30c3\u30af\u51fa\u7248\u793e/\u30e1\u30fc\u30ab\u30fc: \u7fd4\u6cf3\u793e\u767a\u58f2\u65e5: 2007/11/02\u30e1\u30c7\u30a3\u30a2: \u5927\u578b\u672c\u8cfc\u5165: 18\u4eba \u30af\u30ea\u30c3\u30af: 335\u56de\u3053\u306e\u5546\u54c1\u3092\u542b\u3080\u30d6\u30ed\u30b0 (27\u4ef6) \u3092\u898b\u308b \u30e1\u30e2\u3002\u30aa\u30ea\u30b8\u30ca\u30eb\u306e\u30af\u30a8\u30ea\u3092\u305d\u306e\u307e\u307e\u5b9f\u884c\u3057\u3066\u3082\u30a8\u30e9\u30fc\u306b\u306a\u308b\u306e\u3067\u3044\u304f\u3064\u304b\u76f4\u3057\u3066\u3044\u308b Oracle EE 12.1.0.2.v10 -- \u5909\u66f4\u70b9 -- INTERVAL '365' DAY\u306f12.1\u3067\u306f\u30a8\u30e9\u30fc ORA-00920: invalid relational operator \u306b\u306a\u308b -- INTERVAL\u304c364\u306b\u306a\u308b\u3053\u3068\u3082\u3042\u308b\u306e\u3067\u2026","blog_url":"https://www.shigemk2.com/"}