pythonでOracleへ接続したい。
import cx_Oracle import os os.environ["NLS_LANG"] = "Japanese_Japan.AL32UTF8" tns = cx_Oracle.makedsn("192.168.0.1",1521,"ORASID") connection = cx_Oracle.connect("user","pass",tns) #connection = cx_Oracle.connect("user","pass","(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.1) (PORT=1521))(CONNECT_DATA=(SID=ORASID)))") cursor = connection.cursor() agent_cd = '7' sql = """ select agent_cd, agent_name from agents where agent_cd = :agent_cd """ cursor.execute(sql, agent_cd) rows = cursor.fetchall() for agent in rows: print(agent[0], agent[1])