Oracle数据库 统一更新 所选表 中 某一字段 值
select 'UPDATE TQSDE.' || TABLE_NAME || ' SET FINISH_DATE = TO_DATE(''1990-01-01'',''yyyy-mm-dd'') WHERE FINISH_DATE IS NULL;' from tqsde.st_featureinfo where ATT_NAME = 'FINISH_DATE' AND TABLE_NAME LIKE 'GS%';
select 'UPDATE TQSDE.' || TABLE_NAME || ' SET FINISH_DATE = TO_DATE(''1990-01-01'',''yyyy-mm-dd'') WHERE FINISH_DATE IS NULL;' from tqsde.st_featureinfo where ATT_NAME = 'FINISH_DATE' AND TABLE_NAME LIKE 'GS%';