lists in cx_Oracle

infidel saint.infidel at gmail.com
Mon May 2 11:27:00 EDT 2005


Something like this might work for you:

>>> ids= ['D102', 'D103', 'D107', 'D108']
>>> in_clause = ', '.join([':id%d' % x for x in xrange(len(ids))])
>>> sql = "select * from tablename where id in (%s)" % in_clause
>>> import cx_Oracle as ora
>>> con = ora.connect('foo/bar at geewhiz')
>>> cur = con.cursor()
>>> cur.execute(sql, ids)




More information about the Python-list mailing list