{"title":"\u30c8\u30ea\u30c3\u30ad\u30fc\u306a\u3001SELECT * FROM dual","width":"100%","image_url":null,"author_name":"posturan","height":"190","description":"Oracle\u3067\u306f\u3001 SELECT * FROM dual \u306f\u3001\u5217\u540d\uff1d'DUMMY' \u5024\uff1d'X'\u306e1\u884c\u3092\u8fd4\u3059\u3002PostgreSQL \u3067\u306f\u3001\u3001\u3001 dual \u306f\u5b58\u5728\u3057\u306a\u3044\u306e\u3067FROM\u53e5\u3092\u7701\u7565\u3059\u308b\u306e\u3060\u304c\u3001 SELECT * \u3068\u3059\u308b\u3068\u3001 SQL\u30a8\u30e9\u30fc [42601]: ERROR: \u30c6\u30fc\u30d6\u30eb\u6307\u5b9a\u306e\u306a\u3044SELECT *\u306f\u7121\u52b9\u3067\u3059 \u306b\u306a\u308b Oracle\u3068\u540c\u3058\u3053\u3068\u3092\u3059\u308b\u306b\u306f\u3001WITH\u53e5\u3067dual\u3092\u7528\u610f\u3059\u308b WITH dual AS( SELECT 'X' AS DUMMY ) SELECT * FROM dual \u3053\u308c\u3067Oracle\u3068\u540c\u3058\u3053\u3068\u304c\u3067\u304d\u308b\u3002MySQL\u3067\u306f\u3001 SELECT 1 FROM dual \u306f\u2026","provider_name":"Hatena Blog","provider_url":"https://hatena.blog","published":"2025-10-10 20:20:35","author_url":"https://blog.hatena.ne.jp/posturan/","blog_url":"https://oboe2uran.hatenablog.com/","categories":["SQL"],"type":"rich","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Foboe2uran.hatenablog.com%2Fentry%2F2025%2F10%2F10%2F202035\" title=\"\u30c8\u30ea\u30c3\u30ad\u30fc\u306a\u3001SELECT * FROM dual - Oboe\u5439\u304d\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u9ed9\u793a\u9332\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","version":"1.0","url":"https://oboe2uran.hatenablog.com/entry/2025/10/10/202035","blog_title":"Oboe\u5439\u304d\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u9ed9\u793a\u9332"}