[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