{"id":226,"date":"2021-03-29T15:58:19","date_gmt":"2021-03-29T06:58:19","guid":{"rendered":"https:\/\/wp.keaven.cyou\/?p=226"},"modified":"2021-03-29T15:59:38","modified_gmt":"2021-03-29T06:59:38","slug":"%e3%82%ab%e3%83%a9%e3%83%a0%e5%90%8d%e3%82%92%e6%8c%87%e5%ae%9a%e3%81%a7%e3%81%8d%e3%82%8bselect%e7%b5%90%e6%9e%9c%e9%85%8d%e5%88%97","status":"publish","type":"post","link":"https:\/\/wp.keaven.cyou\/?p=226","title":{"rendered":"\u30ab\u30e9\u30e0\u540d\u3092\u6307\u5b9a\u3067\u304d\u308bSELECT\u7d50\u679c\u914d\u5217"},"content":{"rendered":"<pre class=\"line-numbers language-python\"><code># coding: utf-8\r\nimport cx_Oracle as ora\r\n\r\ntns = ora.makedsn('\u30db\u30b9\u30c8\u540d', 1521, 'sid')\r\nconn = ora.connect('\u30e6\u30fc\u30b6\u540d', '\u30d1\u30b9\u30ef\u30fc\u30c9', tns, encoding='utf-8')\r\ncur = conn.cursor()\r\n\r\ncur.execute('SELECT COL1, COL2 FROM TBLNAME')\r\n# Python3\r\ncolumnname = {desc[0]:idx for idx, desc in enumerate(cur.description)}\r\n# Python2\r\n# col = {}\r\n# for (idx, desc) in enumerate(cur.description): col.update({ desc[0]:idx })\r\n\r\nrows = cur.fetchall()\r\n\r\nfor r in rows:\r\n\t# \u914d\u5217\u756a\u53f7\u3067\u6307\u5b9a\r\n\t# print(\"%s, %s\" % (r[0], r[1]))\r\n\t# \u30ab\u30e9\u30e0\u540d\u3067\u6307\u5b9a\r\n\tprint(\"%s %s\" % (r[columnname['COL1']], r[columnname['COL2']]))\r\n\r\nconn.close()<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p># coding: utf-8 import cx_Oracle as ora tns = ora.makedsn(&#8216;\u30db\u30b9\u30c8\u540d&#8217;, 1521, &#8216;sid&#8217;) conn = ora.connect(&#8216;\u30e6\u30fc\u30b6\u540d&#8217;, &#8216;\u30d1\u30b9\u30ef &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/wp.keaven.cyou\/?p=226\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;\u30ab\u30e9\u30e0\u540d\u3092\u6307\u5b9a\u3067\u304d\u308bSELECT\u7d50\u679c\u914d\u5217&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/wp.keaven.cyou\/index.php?rest_route=\/wp\/v2\/posts\/226"}],"collection":[{"href":"https:\/\/wp.keaven.cyou\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.keaven.cyou\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.keaven.cyou\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.keaven.cyou\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=226"}],"version-history":[{"count":2,"href":"https:\/\/wp.keaven.cyou\/index.php?rest_route=\/wp\/v2\/posts\/226\/revisions"}],"predecessor-version":[{"id":228,"href":"https:\/\/wp.keaven.cyou\/index.php?rest_route=\/wp\/v2\/posts\/226\/revisions\/228"}],"wp:attachment":[{"href":"https:\/\/wp.keaven.cyou\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.keaven.cyou\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.keaven.cyou\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}