{"published":"2006-12-06 00:43:17","blog_url":"https://arappocaro.hatenablog.com/","provider_name":"Hatena Blog","height":"190","categories":["IT"],"version":"1.0","type":"rich","author_url":"https://blog.hatena.ne.jp/ArappoCaro/","url":"https://arappocaro.hatenablog.com/entry/20061206/1165419797","blog_title":"\u30a2\u30e9\u30c3\u30dd\u30fb\u30ab\u30fc\u30ed\u306e\u5099\u5fd8\u9332","image_url":null,"title":"Oracle(\u3078\u305f\u308c\u306a)\u30b3\u30cd\u30bf Oracle\u4e0a\u30c7\u30fc\u30bf\u304c\u3001.NET\u306eDataSet\u3078\u306eFill\u3067\u30aa\u30d0\u30fc\u30d5\u30ed\u30fc","description":"Oracle\u306ePL/SQL\u4e0a\u306eSELECT\u6587\u3067\u53d6\u5f97\u3059\u308b\u5217\u9805\u76ee\u306b\u3001\u6bd4\u7387\u306a\u3069\u306e\u6f14\u7b97\u7d50\u679c\u3092\u542b\u3080\u5217\u9805\u76ee\u304c\u5b58\u5728\u3059\u308bSELECT\u6587\u3092\u5229\u7528\u3057\u3066\u3001DataSet\u3078\u30c7\u30fc\u30bf\u3092Fill\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u4f8b\u5916\u304c\u767a\u751f\u3059\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002 SELECT ID,\u6570\u50241/\u6570\u50242 AS Ratio FROM DataTable (DataTale\u306fID\u3068\u6570\u50241\u3001\u6570\u50242\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u304b\u3089\u69cb\u6210) \u3053\u308c\u306f\u3001Oracle \u306e NUMBER \u578b\u306e\u6709\u52b9\u6841\u6570\u306f 38 \u6841\u3067\u3042\u308a\u3001.NET Framework \u306e decimal \u578b\u306f 28 \u6841\u3067\u3042\u308b\u3068\u3044\u3046\u5236\u7d04\u304b\u3089\u3067\u3042\u308b\u3068\u601d\u308f\u308c\u307e\u3059\u3002ACCESS\u306a\u3069\u3067\u30ea\u30f3\u30af\u30c6\u30fc\u30d6\u30eb\u306b\u3066\u6271\u3046\u5834\u5408\u306b\u306f\u52dd\u624b\u306b\u5207\u308a\u6368\u3066\u3089\u308c\u3066\u2026","author_name":"ArappoCaro","provider_url":"https://hatena.blog","width":"100%","html":""}