擅长:python、mysql、java
<p>您需要为列表中的每个项创建一个单独的bind参数,然后将id列表传递到<code>read_sql()</code>:</p>
<pre><code>idlist = ['123456548','546465464']
in_vars = ','.join(':%d' % i for i in range(len(idlist)))
query = """
select PEBEMPL_ECLS_CODE
from PEBEMPL
inner join SPRIDEN on spriden_pidm = pebempl_pidm
where SPRIDEN_CHANGE_IND is null
and SPRIDEN_ID in (%s)
""" % in_vars
df = pd.read_sql(query, connection, params=idlist)
</code></pre>
<p>为了避免混淆,上面的例子使用Pandas<code>read_sql()</code>函数与Oracle对话。对于直接使用<code>cursor</code>对象的人来说,语法是:</p>
^{pr2}$