将csv中的部分数据插入oracle表

import cx_Oracle
import csv

# 连接到Oracle数据库
connection = cx_Oracle.connect("username/password@hostname:port/service_name")

# 创建游标
cursor = connection.cursor()

# 打开CSV文件
with open('data.csv', 'r') as file:
    # 创建CSV读取器
    reader = csv.reader(file)
    
    # 遍历CSV文件的每一行数据
    for row in reader:
        # 提取需要插入的数据
        column1 = row[0]
        column2 = row[1]
        # ...
        
        # 构建插入语句
        sql = "INSERT INTO table_name (column1, column2) VALUES (:1, :2)"
        
        # 执行插入语句
        cursor.execute(sql, (column1, column2))
    
    # 提交事务
    connection.commit()

# 关闭游标和数据库连接
cursor.close()
connection.close()