【Python】批量修改数据库表的字段类型脚本

下面是批量修改数据库表字段类型，如批量把clob改成nclob：

import cx_Oracle

# 设置数据库连接信息
username = 'db_username'
password = 'your_password'  # 请替换为实际的数据库密码
dsn = 'your_dsn'  # 请替换为实际的数据库DSN

# 创建数据库连接
connection = cx_Oracle.connect(username, password, dsn)

# 定义要修改的字段类型
oldType = 'CLOB'
newType = 'NCLOB'

# 查询包含CLOB字段的表信息
cursor = connection.cursor()
sql = f"""SELECT OWNER,
                 TABLE_NAME,
                 COLUMN_NAME,
                 DATA_TYPE,
                 DATA_LENGTH AS COLUMN_LENGTH
          FROM ALL_TAB_COLUMNS
          WHERE OWNER = UPPER('{
     username}') AND DATA_TYPE = '{
     oldType}'"""
cursor.execute(sql)
result = cursor