[PYTHON DB-SIG] Re: Looking for examples of oracledb usage
Anthony Baxter <email@example.com>
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: firstname.lastname@example.org
administrivia to: email@example.com