{"id":2528,"date":"2017-01-26T15:00:50","date_gmt":"2017-01-26T06:00:50","guid":{"rendered":"http:\/\/www.whoocus.com\/blog\/?p=2528"},"modified":"2017-01-26T15:05:45","modified_gmt":"2017-01-26T06:05:45","slug":"cx_oracle-%e3%81%a7oracle%e6%8e%a5%e7%b6%9a","status":"publish","type":"post","link":"https:\/\/www.blowfish.co.jp\/?p=2528","title":{"rendered":"cx_Oracle \u3067Oracle\u63a5\u7d9a"},"content":{"rendered":"<p>\u958b\u767a\u74b0\u5883\u304c\u3001Windows\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u306fSJIS\u3002<\/p>\n<p>cx_Oracle\u3092\u4f7f\u7528\u3057\u3066\u3001Oracle\u63a5\u7d9a\u3092\u3057\u3066\u307f\u305f\u304c\u3001\u3069\u3046\u3057\u3066\u3082\u51fa\u529b\u7d50\u679c\u304c\u6587\u5b57\u5316\u3051\u3057\u3066\u3057\u307e\u3046\u3002<br \/>\n\u305d\u3053\u3067\u3001\u4e0b\u8a18\u306b\u3066\u74b0\u5883\u5909\u6570\u3092\u6307\u5b9a\u3057\u3066\u307f\u305f\u3002<\/p>\n<p>[python]<br \/>\nimport os<br \/>\nos.environ[&quot;NLS_LANG&quot;] = &quot;JAPANESE_JAPAN.JA16SJISTILDE&quot;<br \/>\n[\/python]<\/p>\n<p>[python]<br \/>\nimport cx_Oracle<br \/>\nimport os<\/p>\n<p>os.environ[&quot;NLS_LANG&quot;] = &quot;JAPANESE_JAPAN.JA16SJISTILDE&quot;<br \/>\ndb_user = &#8216;user&#8217;<br \/>\ndb_pass = &#8216;xxxx&#8217;<br \/>\ndb_host = &#8216;(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521)) (CONNECT_DATA =(SERVER = DEDICATED)(SID = HOGE)))&#8217;<br \/>\ncon = cx_Oracle.connect(db_user, db_pass, db_host)<\/p>\n<p>cur = con.cursor()<br \/>\nsql = &#8216;select member_id, member_name from members order by 1&#8217;<br \/>\ncur.execute(sql)<br \/>\nrows = cur.fetchall()<br \/>\nfor row in rows:<br \/>\n    member_id = row[0]<br \/>\n    member_name = row[1]<br \/>\n    print( member_name)<br \/>\n[\/python]<\/p>\n<p>\u3046\u307e\u304f\u3044\u3063\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u958b\u767a\u74b0\u5883\u304c\u3001Windows\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u306fSJIS\u3002 cx_Oracle\u3092\u4f7f\u7528\u3057\u3066\u3001Oracle\u63a5\u7d9a\u3092\u3057\u3066\u307f\u305f\u304c\u3001\u3069\u3046\u3057\u3066\u3082\u51fa\u529b\u7d50\u679c\u304c\u6587\u5b57\u5316\u3051\u3057\u3066\u3057\u307e\u3046\u3002 \u305d\u3053\u3067\u3001\u4e0b\u8a18\u306b\u3066\u74b0\u5883\u5909\u6570\u3092\u6307\u5b9a\u3057\u3066\u307f\u305f\u3002 [pyt [&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,45,4],"tags":[],"class_list":["post-2528","post","type-post","status-publish","format-standard","hentry","category-oracle","category-python","category-tech"],"_links":{"self":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/2528","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=2528"}],"version-history":[{"count":2,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/2528\/revisions"}],"predecessor-version":[{"id":2530,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/2528\/revisions\/2530"}],"wp:attachment":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2528"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2528"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2528"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}