SELECT ‘UPDATE ‘||A.TABLE_NAME||’ SET 字段名 = 值;’ FROM (
select table_name from user_col_comments where column_name = ‘字段名’) A;
oracle根据字段名查询表名且修改所有表的这个字段名的值
最新推荐文章于 2022-06-21 16:39:33 发布
SELECT ‘UPDATE ‘||A.TABLE_NAME||’ SET 字段名 = 值;’ FROM (
select table_name from user_col_comments where column_name = ‘字段名’) A;