<h2>简短回答:</h2>
<pre><code>query = """
insert into TABLE(FIELD1, FIELD2, ...) values (VAL1, VAL2, ...)
"""
cur = con.cursor()
cur.execute(query)
cur.commit()
</code></pre>
<p>我强烈建议您使用<a href="https://stackoverflow.com/questions/23829828/python-cx-oracle-prepared-statement-with-qmark">prepared statements</a>。在</p>
<h2>长话短说:</h2>
<p>这是针对Linux的,特别是针对Red Hat。只有末尾的Python代码可以在每个操作系统上使用。尝试使这些步骤适应您的操作系统。在</p>
<p>0:安装包<code>libaio</code>和<code>python-dev</code>(或python-devel,检查发行版)</p>
<p>1:如果没有<code>pip</code>,请安装它</p>
<p>2:从<a href="http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html" rel="nofollow noreferrer">Oracle site</a>安装oracle <code>instantclient-basic</code>和{<cd5>}(或<code>instantclient-devel</code>)</p>
<p>3:使用<code>bash</code>启动这些命令。如果您没有<code>/etc/profile.d/</code>,请检查您的发行版。在</p>
^{pr2}$
<p>4:注销并重新登录</p>
<p>5:在使用cx Oracle之前,您必须设置<code>LD_LIBRARY_PATH</code>我建议您<strong>而不是</strong>全局设置它:</p>
<pre><code>export LD_LIBRARY_PATH="$ORACLE_HOME/lib"
</code></pre>
<p>6:最后,Python代码:</p>
<pre><code>import cx_Oracle
os.environ["NLS_LANG"] = "AMERICAN_AMERICA.UTF8"
con_str = "USERNAME/PASSWORD@HOST:PORT/DBNAME"
con = cx_Oracle.connect(con_str)
query = """
select 1 from dual
"""
cur = con.cursor()
cur.execute(query)
rows = cur.fetchall()
for row in rows:
print(row) # it should print "1"
con.close()
</code></pre>
<p>您必须用您的用户名、密码等更改<code>con_str</code>。设置{<cd11>}编码的行是可选的,可以根据您的需要进行调整,但建议这样做。在</p>
<p>7:如果要插入行:</p>
<pre><code>query = """
insert into TABLE(FIELD1, FIELD2, ...) values (VAL1, VAL2, ...)
"""
cur = con.cursor()
cur.execute(query)
cur.commit()
</code></pre>
<p>如果您不能信任数据的来源,我强烈建议您使用<a href="https://stackoverflow.com/questions/23829828/python-cx-oracle-prepared-statement-with-qmark">prepared statements</a>。在</p>
<p>资料来源:</p>
<ol>
<li><a href="http://chilipuppy.blogspot.it/2008/10/purpose-im-working-on-building-python.html" rel="nofollow noreferrer">http://chilipuppy.blogspot.it/2008/10/purpose-im-working-on-building-python.html</a></li>
<li><a href="http://agiletesting.blogspot.it/2005/05/installing-and-using-cxoracle-on-unix.html" rel="nofollow noreferrer">http://agiletesting.blogspot.it/2005/05/installing-and-using-cxoracle-on-unix.html</a></li>
<li><a href="http://cx-oracle.readthedocs.org/en/latest/index.html" rel="nofollow noreferrer">http://cx-oracle.readthedocs.org/en/latest/index.html</a></li>
<li>私人纠纷</li>
</ol>