{"author_url":"https://blog.hatena.ne.jp/argius/","provider_url":"https://hatena.blog","image_url":null,"published":"2009-02-24 09:39:47","categories":["database"],"width":"100%","type":"rich","title":"Oracle SQL*Plus NUMBER\u578b\u306e\u8868\u793a\u6841\u6570\u3092\u6307\u5b9a","height":"190","description":"Oracle/SQL*Plus - \u304a\u3057\u3054\u3068\u304a\u307c\u3048\u304c\u304d Wiki* NUMBER\u578b\u3067\u6841\u304c\u5927\u304d\u3044\u3068\u3001\u6307\u6570\u8868\u8a18\u306b\u306a\u308a\u307e\u3059(\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f>10\u6841)\u3002 SQL> SELECT 1234567890 FROM DUAL; 1234567890 ---------- 1234567890 SQL> SELECT 12345678901 FROM DUAL; 12345678901 ----------- 1.2346E+10NUMWIDTH\u306e\u5024\u3092\u5909\u66f4\u3059\u308b\u3068\u3001\u6307\u6570\u8868\u8a18\u306b\u3057\u306a\u3044\u30b5\u30a4\u30ba\u3092\u5909\u66f4\u3067\u304d\u307e\u3059\u3002 SQL> SHOW NUMWIDTH numwidth 10 SQL> SET NUMWIDTH 11 SQ\u2026","url":"https://argius.hatenablog.jp/entry/20090224/1235435987","blog_url":"https://argius.hatenablog.jp/","author_name":"argius","blog_title":"argius note","version":"1.0","provider_name":"Hatena Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fargius.hatenablog.jp%2Fentry%2F20090224%2F1235435987\" title=\"Oracle SQL*Plus NUMBER\u578b\u306e\u8868\u793a\u6841\u6570\u3092\u6307\u5b9a - argius note\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}