-增加一个和原字段名同名的字段TEST_AGE
alter table T_PROD_GROUP_TERM add ACTUAL_PAY NUMBER(20,2);
--将原字段TEST_AGE_TMP数据更新到增加的字段TEST_AGE
update T_PROD_GROUP_TERM set ACTUAL_PAY=trim(ACTUAL_PAYS);
--更新完,删除原字段TEST_AGE_TMP
alter table T_PROD_GROUP_TERM drop column ACTUAL_PAYS;
select * from T_PROD_GROUP_TERM as of timestamp to_timestamp('2019-05-14 17:14:40','yyyy-mm-dd hh24:mi:ss')
select A.GROUP_ID from (select * from T_PROD_GROUP_TERM as of timestamp to_timestamp('2019-05-14 15:28:40','yyyy-mm-dd hh24:mi:ss')
WHERE CLEAR_DATE >to_date('2019-05-14 12:00:00','yyyy-mm-dd hh24:mi:ss'))
) A ,(select * from T_PROD_GROUP_TERM as of timestamp to_timestamp('2019-05-14 15:28:48','yyyy-mm-dd hh24:mi:ss')
WHERE CLEAR_DATE >to_date('2019-05-14 12:00:00','yyyy-mm-dd hh24:mi:ss'))
) B
where A.GROUP_ID not in B.GROUP_ID
flashback table T_PROD_GROUP_TERM to timestamp to_timestamp('2019-05-14 1:20:10','yyyy-mm-dd hh24:mi:ss')
alter table T_PROD_GROUP_TERM enable row movement