//数据库开启表回滚
alter table TSYS_ROLE enable row movement;
//数据库表回滚
flashback table TSYS_ROLE to timestamp to_timestamp(‘2019-10-27 05:00:00’,‘yyyy-mm-dd HH24:MI:SS’);
//添加字段
alter table “INTR”.“TABLE_CCED” add (“HOLD_DATE” VARCHAR2(10 BYTE))
//添加备注
COMMENT ON COLUMN “INTR”.“TABLE_CCED”.“HOLD_DATE” IS ‘持仓截止日期’;