[DB-SIG] Insert for Oracledb

Hiren Hindoccha hiren@lexis-nexis.com
Fri, 21 Nov 1997 10:15:49 -0500 (EST)

On Fri, 21 Nov 1997, Victoria White wrote:

> Please can someone send me a working code sample of how they
> successfully used the oracledb module (from Digital Creations) to insert

Wouldn't the following work - 

stmt = """
INSERT INTO people VALUES ('%s','%s','%s','%s','%s','%s','%s','%s',%s); """

sqlstmt = stmt % (your_tuple)

I've used the above to do the inserts. Is the problem that you don't
want to specify the data types that should be inserted into the table  ? 

"!sgub evah t'nseod CP sihT ?sgub naem ayaddahW"

DB-SIG  - SIG on Tabular Databases in Python

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