{"id":2145,"date":"2014-07-15T16:11:27","date_gmt":"2014-07-15T07:11:27","guid":{"rendered":"http:\/\/www.whoocus.com\/blog\/?p=2145"},"modified":"2014-07-15T16:11:27","modified_gmt":"2014-07-15T07:11:27","slug":"db%e3%81%a7%e6%9c%80%e5%88%9d%e3%81%ab%e6%b1%ba%e3%82%81%e3%81%a6%e3%81%8a%e3%81%8f%e3%81%a8%e8%89%af%e3%81%84%e8%a6%8f%e7%b4%84%e4%be%8b","status":"publish","type":"post","link":"https:\/\/www.blowfish.co.jp\/?p=2145","title":{"rendered":"DB\u3067\u6700\u521d\u306b\u6c7a\u3081\u3066\u304a\u304f\u3068\u826f\u3044\u898f\u7d04\u4f8b"},"content":{"rendered":"<p>\u25a0\u898f\u7d04<br \/>\n\u25cbID\u9805\u76ee\u306e\u53d6\u308a\u6271\u3044\u306b\u3064\u3044\u3066<br \/>\n\u3000\u30fbNumber(18)\u578b\u3068\u3059\u308b<\/p>\n<p>\u25cb\u91d1\u984d\u9805\u76ee\u306e\u53d6\u308a\u6271\u3044\u306b\u3064\u3044\u3066<br \/>\n\u3000\u30fbNumber(19)\u578b\u3068\u3059\u308b<\/p>\n<p>\u25cb\u5c0f\u6570\u70b9\u306e\u53d6\u6271\u3044\u306b\u3064\u3044\u3066<br \/>\n\u3000\u30fbNumber(9, 6)\u578b\u3092\u4f7f\u7528\u3059\u308b<\/p>\n<p>\u25cb\u30d1\u30fc\u30bb\u30f3\u30c8(%)\u8868\u793a\u306b\u3064\u3044\u3066<br \/>\n\u3000\u30fb1% \u8868\u793a\u306e\u5834\u5408\u30010.01 \u3092\u5b9f\u30c7\u30fc\u30bf\u3068\u3057\u3066\u683c\u7d0d\u3059\u308b<\/p>\n<p>\u25cbDB\u3078\u306e\u683c\u7d0d\u30eb\u30fc\u30eb(Oracle\u306e\u5834\u5408)<br \/>\n\u3000\u30fbDB\u3078\u306e\u683c\u7d0d\u306f\u3001Number\u578b(9,6)\u3067\u683c\u7d0d<br \/>\n\u3000\u3000\u3000\u246098.7654321  \u2192 98.765432 \u30c7\u30fc\u30bf\u304c\u683c\u7d0d\u3055\u308c\u308b(\u56db\u6368\u4e94\u5165)<br \/>\n\u3000\u3000\u3000\u246198.7654325  \u2192 98.765433 \u30c7\u30fc\u30bf\u304c\u683c\u7d0d\u3055\u308c\u308b(\u56db\u6368\u4e94\u5165)<br \/>\n\u3000\u3000\u3000\u246298.76543211 \u2192 \u7cbe\u5ea6\u3092\u8d85\u3048\u3066\u3044\u308b\u70ba\u306b\u30a8\u30e9\u30fc<br \/>\n\u3000\u3000\u3000\u3000\u203b\u5c0f\u6570\u70b9\u7b2c7\u4f4d\u4ee5\u4e0b\u306f\u56db\u6368\u4e94\u5165\u3067\u4e38\u3081\u3089\u308c\u308b<\/p>\n<p>\u25cb\u753b\u9762\u3078\u306e\u8868\u793a\u30eb\u30fc\u30eb<br \/>\n\u3000\u30fb\u30d1\u30fc\u30bb\u30f3\u30c8\u8868\u793a\u9805\u76ee\u306f1%\u3068\u8868\u793a\u3057\u3066\u3044\u308b\u5834\u5408\u30010.01\u3092 Number\u578b(9,6)\u3067\u683c\u7d0d<br \/>\n\u3000\u3000\u3000\u24600.01234 \u2192 1.23% \u3068\u8868\u793a\u3059\u308b<br \/>\n\u3000\u3000\u3000\u24610.01239 \u2192 1.23% \u3068\u8868\u793a\u3059\u308b<br \/>\n\u3000\u3000\u3000\u3000\u203b\u5c0f\u6570\u7b2c3\u4f4d\u4ee5\u4e0b\u306e\u8868\u793a\u306f\u5207\u308a\u6368\u3066<\/p>\n<p>\u25cb\u5e74\u6708\u65e5\u306e\u578b\u306b\u3064\u3044\u3066<br \/>\n\u3000\u30fbyyyymmdd \u306fNumber(8, 0) \u3068\u3059\u308b<\/p>\n<p>\u25cb\u6642\u9593\u306e\u578b\u306b\u3064\u3044\u3066<br \/>\n\u3000\u30fbhhmm \u306fNumber(4, 0) \u3068\u3059\u308b<\/p>\n<p>\u25cb\u65e5\u6642\u9805\u76ee\u306b\u3064\u3044\u3066<br \/>\n\u3000\u30fb\u66f4\u65b0\u65e5\u6642\u306f\u3001\u30d0\u30c3\u30c1\u51e6\u7406\u306e\u5b9f\u884c\u65e5\u6642<br \/>\n\u3000\u30fb\u30c7\u30fc\u30bf\u57fa\u6e96\u65e5\u306f\u3001\u5143\u30c7\u30fc\u30bf\u306e\u57fa\u6e96\u65e5\u6642<br \/>\n\u3000\u30fb\u5e33\u7968\u4f5c\u6210\u65e5\u306f\u3001\u30c7\u30fc\u30bf\u306e\u767b\u9332\u66f4\u65b0\u65e5\u6642<\/p>\n<p>\u25cb\u8868\u793a\u3059\u308b\u5024\u306b\u3064\u3044\u3066<br \/>\n\u3000\u30fb0 = 0<br \/>\n\u3000\u30fbnull = \u7a7a\u6b04<br \/>\n\u3000\u30fb\u5024\u306a\u3057 = \u30cf\u30a4\u30d5\u30f3 &#8220;-&#8220;\u8868\u793a<br \/>\n\u3000\u30fb\u6bd4\u306e\u9805\u76ee \u300c+\u300d\u300c-\u300d\u3092\u4ed8\u52a0\u8868\u793a<\/p>\n<p>\u25cb\u30b7\u30fc\u30b1\u30f3\u30b9\u540d\u306b\u3064\u3044\u3066<br \/>\n\u3000\u30fbSEQ_\u30c6\u30fc\u30d6\u30eb\u540d \u306b\u3066\u4f5c\u6210\u3059\u308b\u3053\u3068<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u25a0\u898f\u7d04 \u25cbID\u9805\u76ee\u306e\u53d6\u308a\u6271\u3044\u306b\u3064\u3044\u3066 \u3000\u30fbNumber(18)\u578b\u3068\u3059\u308b \u25cb\u91d1\u984d\u9805\u76ee\u306e\u53d6\u308a\u6271\u3044\u306b\u3064\u3044\u3066 \u3000\u30fbNumber(19)\u578b\u3068\u3059\u308b \u25cb\u5c0f\u6570\u70b9\u306e\u53d6\u6271\u3044\u306b\u3064\u3044\u3066 \u3000\u30fbNumber(9, 6)\u578b\u3092\u4f7f\u7528\u3059\u308b \u25cb\u30d1\u30fc\u30bb\u30f3\u30c8(% [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"saved_in_kubio":false,"footnotes":""},"categories":[12,4],"tags":[],"class_list":["post-2145","post","type-post","status-publish","format-standard","hentry","category-oracle","category-tech"],"_links":{"self":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/2145","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2145"}],"version-history":[{"count":1,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/2145\/revisions"}],"predecessor-version":[{"id":2146,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/2145\/revisions\/2146"}],"wp:attachment":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}