Re: [cx-oracle-users] UPDATE examples

[Robert <web...@gm...>]

How to find out number of rows affected by UPDATE/DELETE... ?

thanks


On Thu, Nov 18, 2010 at 12:34 PM, Mark Harrison <mh...@pi...> wrote:
> 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
>
> ------------------------------------------------------------------------------
> Beautiful is writing same markup. Internet Explorer 9 supports
> standards for HTML5, CSS3, SVG 1.1,  ECMAScript5, and DOM L2 & L3.
> Spend less time writing and  rewriting code and more time creating great
> experiences on the web. Be a part of the beta today
> http://p.sf.net/sfu/msIE9-sfdev2dev
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>