达梦数据库（DM）通过数据库类型生成修改字段类型的语句

 

 

SELECT 'ALTER TABLE "' || TABLE_NAME || '" MODIFY "' || COLUMN_NAME || '" DECIMAL(19,3);' AS ALTER_SQL
FROM USER_TAB_COLUMNS
WHERE DATA_TYPE = 'DOUBLE';