Re: [cx-oracle-users] UPDATE examples

[Mark H. <mh...@pi...>]

On 11/17/10 10:14 PM, Robert wrote:
> I searched "cx_Oracle-doc" folder for UPDATE examples but can not find
> any. (even Google can't seem to find any, sigh)
>
> please provide an UPDATE example (with parameters)

try one of these:


# execute with positional parameter :1=first, :2=second, etc
curs.execute('select :1 * :2 from dual',[2,4])
print curs.fetchone()[0]

# execute with named parameter  :
curs.execute('select :x * :y from dual',x=2,y=5)
print curs.fetchone()[0]




more cx_Oracle examples at:

     http://markharrison.net/cx-oracle-demos


HTH!
Mark