如何将xml中的分层数据插入到oracle表中

import cx_Oracle
import xml.etree.ElementTree as ET

# 解析XML数据
tree = ET.parse('data.xml')
root = tree.getroot()

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

# 创建表结构
cursor = connection.cursor()
cursor.execute('CREATE TABLE xml_data (id NUMBER, name VARCHAR2(100), value NUMBER)')

# 插入数据
for child in root:
    id = int(child.attrib['id'])
    name = child.find('name').text
    value = float(child.find('value').text)
    cursor.execute('INSERT INTO xml_data VALUES (:1, :2, :3)', (id, name, value))

# 提交事务
connection.commit()

# 关闭连接
cursor.close()
connection.close()

<data>
    <record id="1">
        <name>John</name>
        <value>100.0</value>
    </record>
    <record id="2">
        <name>Jane</name>
        <value>200.0</value>
    </record>
</data>