Re: [cx-oracle-users] UPDATE examples

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

Anurag, yes, thanks but I'm really looking for "real-world" examples,
i.e. ones that uses bind variable/parameters in WHERE clause.
The examples in cx_Oracle doc all seem to be simple type like you provided.


On Thu, Nov 18, 2010 at 1:27 AM, Anurag Chourasia
<anu...@gm...> wrote:
> Hi Robert,
> Are you looking at something like this?
> connection = cx_Oracle.connect(Connection_String)
> cursor = connection.cursor()
> query = "UPDATE <TABLE> SET <COLUMN>=<VALUE> WHERE <Where Clause>"
> cursor.execute(str(query))
> connection.commit()
> Regards,
> Anurag