Python-сообщество

con = cx_Oracle.connect('user/pass@127.0.0.1/mybase')
cur = con.cursor()
example = {
    "id": "8",
    "name": "example",
    "datatim": datetime.datetime.now()
    }
cur.execute
( "insert into table (ID_FILE, NAME_FILE, SYS_CREATION_DATE) values (:id, :name, :datatim)", example )
con.commit()
cur.close()
con.close()

example = {
    ":id": "8",
    ":name": "example",
    ":datatim": datetime.datetime.now()
    }

str(datetime.datetime.now())

example = [8, "example", datetime.datetime.now()]
cur.execute
( "insert into table (ID_FILE, NAME_FILE, SYS_CREATION_DATE) values (%s, %s, %s)", example )

create table mytab (id number, data varchar2(20));

import cx_Oracle
con = cx_Oracle.connect('pythonhol/welcome@127.0.0.1/orcl')
rows = [ (1, "First" ),
         (2, "Second" ),
         (3, "Third" ),
         (4, "Fourth" ),
         (5, "Fifth" ),
         (6, "Sixth" ),
         (7, "Seventh" ) ]
cur = con.cursor()
cur.bindarraysize = 7
cur.setinputsizes(int, 20)
cur.executemany("insert into mytab(id, data) values (:1, :2)", rows)
con.commit()
cur.close()
сon.close()

create table "table" 
(ID_FILE number(5) constraint "FILE_ID" primary key,
NAME_FILE varchar2(256)
"SYS_CREATION_DATE" DATE CONSTRAINT "SYS_CREATION_DATE_NN" NOT NULL ENABLE);