{"id":2418,"date":"2016-03-18T13:11:51","date_gmt":"2016-03-18T04:11:51","guid":{"rendered":"http:\/\/www.whoocus.com\/blog\/?p=2418"},"modified":"2016-03-18T19:40:34","modified_gmt":"2016-03-18T10:40:34","slug":"windows7%e3%81%a7python3-5%e7%92%b0%e5%a2%83%e3%81%a7-cx_oracle%e3%82%92%e4%bd%bf%e3%81%86","status":"publish","type":"post","link":"https:\/\/www.blowfish.co.jp\/?p=2418","title":{"rendered":"Windows7\u3067Python3.5\u74b0\u5883\u3067 cx_Oracle\u3092\u4f7f\u3046"},"content":{"rendered":"<p>python\u3067Oracle\u3078\u63a5\u7d9a\u3057\u305f\u3044\u3002<\/p>\n<p>[python]<br \/>\nimport cx_Oracle<br \/>\nimport os<br \/>\nos.environ[&quot;NLS_LANG&quot;] = &quot;Japanese_Japan.AL32UTF8&quot;<\/p>\n<p>tns = cx_Oracle.makedsn(&quot;192.168.0.1&quot;,1521,&quot;ORASID&quot;)<br \/>\nconnection = cx_Oracle.connect(&quot;user&quot;,&quot;pass&quot;,tns)<br \/>\n#connection = cx_Oracle.connect(&quot;user&quot;,&quot;pass&quot;,&quot;(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.1) (PORT=1521))(CONNECT_DATA=(SID=ORASID)))&quot;)<\/p>\n<p>cursor = connection.cursor()<br \/>\nagent_cd = &#8216;7&#8217;<br \/>\nsql = &quot;&quot;&quot;<br \/>\n    select agent_cd, agent_name<br \/>\n      from agents<br \/>\n     where agent_cd = :agent_cd<br \/>\n    &quot;&quot;&quot;<br \/>\ncursor.execute(sql, agent_cd)<br \/>\nrows = cursor.fetchall()<br \/>\nfor agent in rows:<br \/>\n    print(agent[0], agent[1])<\/p>\n<p>[\/python]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>python\u3067Oracle\u3078\u63a5\u7d9a\u3057\u305f\u3044\u3002 [python] import cx_Oracle import os os.environ[&quot;NLS_LANG&quot;] = &quot;Japanese_Jap [&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":[45,4],"tags":[],"class_list":["post-2418","post","type-post","status-publish","format-standard","hentry","category-python","category-tech"],"_links":{"self":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/2418","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=2418"}],"version-history":[{"count":4,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/2418\/revisions"}],"predecessor-version":[{"id":2426,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/2418\/revisions\/2426"}],"wp:attachment":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2418"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2418"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}