import cx_Oracle as ora
from datetime import datetime
# 连接oracle
db_conn = ora.connect('scott', 'admin', '192.168.1.113:1521/orcl')
db_cursor=db_conn.cursor()
sql_cmd = 'INSERT INTO student(sno, sname, sage,ssex) VALUES(:sno, :sname, :sage,:ssex)'
db_cursor.executemany(sql_cmd, [(15, 'qq', 12, '女'),(16, 'qq', 12, '女')])
db_conn.commit()
db_cursor.close()
db_conn.close()
二、删除
import cx_Oracle as ora
from datetime import datetime
# 连接oracle
db_conn = ora.connect('scott', 'admin', '192.168.1.110:1521/orcl')
db_cursor=db_conn.cursor()
sql_cmd = 'delete from student where sno=15 and sno=16'
db_cursor.executemany(sql_cmd ,[])
db_conn.commit()
db_cursor.close()
db_conn.close()