Oracle with Python -如何检查列是否已存在？

import cx_Oracle

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

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

# 检查列是否存在的SQL语句
sql = "SELECT COUNT(*) FROM USER_TAB_COLUMNS WHERE TABLE_NAME = 'your_table_name' AND COLUMN_NAME = 'your_column_name'"

# 执行SQL语句
cursor.execute(sql)

# 获取查询结果
result = cursor.fetchone()

# 判断列是否存在
if result[0] > 0:
    print("列已存在")
else:
    print("列不存在")

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