SELECT 'ALTER TABLE ' || OWNER || '.' || TABLE_NAME || ' MODIFY ' || COLUMN_NAME || ' DATETIME;' AS alter_sql FROM ALL_TAB_COLUMNS WHERE DATA_TYPE = 'DATE' and OWNER='PS_EXAMPLEDBUSER' order by COLUMN_NAME asc
达梦数据库查询字段类型为Date 修改为DateTime
深耕网站建设、视觉设计与SEO优化的一线实战洞察。
SELECT 'ALTER TABLE ' || OWNER || '.' || TABLE_NAME || ' MODIFY ' || COLUMN_NAME || ' DATETIME;' AS alter_sql FROM ALL_TAB_COLUMNS WHERE DATA_TYPE = 'DATE' and OWNER='PS_EXAMPLEDBUSER' order by COLUMN_NAME asc