python - 如何将 cx_Oracle 查询中的 '?' 替换为提供的值

Question

 cur.execute('select* form table where a = '?' and b = '?' and c = '?'', (val1,val2,val3))

我想用 val1,2,3 替换这些占位符

Answer 1

Oracle 不使用“?”作为绑定(bind)变量的占位符。它使用冒号前缀的名称，例如 :1 或 :empno。

参见Using Bind Variables在 cx_Oracle 文档中。另请查看 examples .

尝试如下:

cur.execute('select * from table where a = :abv and b = :bbv and c = :cbv', [val1, val2, aval3])

或

cur.execute('select * from table where a = :abv and b = :bbv and c = :cbv', abv = val1, bbv = val2, cbv = val3])