[PYTHON DB-SIG] Re: Looking for examples of oracledb usage

Anthony Baxter Anthony Baxter <arb@connect.com.au>
Fri, 18 Apr 1997 11:46:37 +1000

>>> Greg Stein wrote
> 1)	you don't need to worry about escaping string values
> 2)	certain types of values *can't* be specified in the SQL
> statement (typically, LONG/BLOB/IMAGE.. whatever you want to call it)
> 3)	you can actually achieve higher efficiencies using parameter
> binding. The standard sequence of operations with a database is: parse

You can also, in theory, bind a list of parameter tuples, and it will apply the
list one tuple at a time. The current oracle db doesnt do this - I've nearly
got it working now.

> You will see the use of "?" in some database interfaces rather than the
> :N syntax (which comes from Oracle, actually). The :N variety was chosen
> because binding positionally is quite handy in a variety of contexts.

There's also the :keyword syntax, which the DB-SIG API doesn't support...


DB-SIG  - SIG on Tabular Databases in Python

send messages to: db-sig@python.org
administrivia to: db-sig-request@python.org