oracle数据库表与字段常用操作

//数据库开启表回滚

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 ‘持仓截止日期’;