[DB-SIG] client side sub queries
Carl Karsten
carl at personnelware.com
Thu May 24 22:10:56 CEST 2007
> There is also Option 3: Use actual parameter passing to build a WHERE ... IN
> (...) clause:
>
> cSql = ("select ktbl2_fk from tbl3 where OtherKey IN ("
> +",".join("%s" for _ in cList)
> +")" )
> cur.execute(cSql, cList)
Don't suppose you know off the top of your head how to code it for
.paramstyle=named
>>> print cx_Oracle.paramstyle
named
Carl K
More information about the DB-SIG
mailing list