擅长:python、mysql、java
<p>您的代码只有几个问题:</p>
<ul>
<li>将<code>cx_Oracle.Connection</code>替换为<code>cx_Oracle.connect</code></li>
<li>注意与<code>print(row)</code>相关的缩进</li>
<li>SELECT语句中的三重双引号是多余的,
用单双引号替换它们</li>
<li><p>宁愿使用<code>print(row[0])</code>来返回所需的数字,而不是
打印的元组</p>
<pre><code>import cx_Oracle
conn = cx_Oracle.connect('user/pwd@localhost:1521/orcl')
cursor = conn.cursor()
query = "SELECT EXTRACTVALUE(xmltype(t.xml),'/DCResponse/ResponseInfo/ApplicationId')"
query += " FROM tab t "
query += " WHERE t.ID = 2 "
cursor.execute( query )
for row in cursor:
print(row[0])
</code></pre></li>
</ul>
<p>如本例中所述,将查询分配给变量不是必需的,但最好使用它以恰当地显示长SELECT语句</p>