Inserting a DataFrame using python-oracledb from the video "Python DataFrames with Oracle Database for Analysis and AI" https://youtu.be/0BJNlbh71LY For other examples, see https://github.com/oracle/python-oracledb/tree/main/samples

insert.py

# insert.py
#
# For other python-oracledb DataFrame examples, see https://github.com/oracle/python-oracledb/tree/main/samples

import os

import pandas
import oracledb

un = os.environ.get('ORACLE_USERNAME')
pw = os.environ.get('ORACLE_PASSWORD')
cs = os.environ.get('ORACLE_DSN')

connection = oracledb.connect(user=un, password=pw, dsn=cs)
cursor = connection.cursor()

#-------------------------------------------------------------------------------

cursor.execute("drop table if exists mytab")
cursor.execute("create table mytab (k number, v varchar2(20))")

#-------------------------------------------------------------------------------

d = {'k': [10, 20, 30],
     'v': ["koala", "wombat", "kangaroo"]}
df = pandas.DataFrame(data=d)

cursor.executemany("insert into mytab (k, v) values (:1, :2)", df)

#-------------------------------------------------------------------------------

print()

for r in cursor.execute("select * from mytab"):
    print(r)

print()