SELECT'alter table '||TABLE_NAME||' add supplemental log group OGG001 ('||WMSYS.WM_CONCAT(COLUMN_NAME)||') always;'
FROM USER_TAB_COLUMNS
GROUP BY TABLE_NAME;
效果:
alter table AIRPORTS add supplemental log group OGG001 (CODE,DESCRIPTION) always;
alter table AREA add supplemental log group OGG001 (ID,AREAID,AREANAME,AREASTATUS,AREAPARENT) always;