This is common operation of oracle table.

oracle_operate.md

• alter column type:

alter table rfd_fms.worklog modify (content varchar2(400));

• add column:

alter table rfd_fms.pixiu_codcheck add flag number(1) default 0 not null;
comment on column rfd_fms.pixiu_codcheck.flag is '标识, 0:妥投 1:全单';

• create table:

CREATE TABLE RFD_FMS.PIXIU_UP_REPORT_BASEINFO
(
  ID                NUMBER          NOT NULL,
  FREIGHTINFOID     NUMBER          NOT NULL,
  ACCOUNTMONTH      DATE            NOT NULL,
  REPORTDATE        DATE            NOT NULL,
  REPORTTYPE        NUMBER          DEFAULT 0,
  TOTALAMOUNT       NUMBER          NULL,
  PERIODBANKAMOUNT  NUMBER          NULL,
  TOTALBANKAMOUNT   NUMBER          NULL,
  TOTALDEBT         NUMBER          NULL,
  PERIODSTARTTIME   DATE            NULL,
  PERIODENDTIME     DATE            NULL,
  ISDELETED         NUMBER          DEFAULT 0,
  CREATETIME        DATE            NOT NULL,
  UPDATETIME    	  DATE            NOT	NULL
);


COMMENT ON TABLE RFD_FMS.PIXIU_UP_REPORT_BASEINFO IS '商家运费报表明细'; 
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.ID IS 'ID'; 
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.FREIGHTINFOID IS '商家账期基础信息表ID';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.ACCOUNTMONTH IS '商家运费账单记录表（账单月份）';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.REPORTDATE IS '出报表时间点';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.REPORTTYPE IS '报表类型 0:周报 1:月报';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.PERIODBANKAMOUNT IS '报表周期回款';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.TOTALAMOUNT IS '应收金额总计';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.TOTALBANKAMOUNT IS '回款总计';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.TOTALDEBT IS '欠款总计';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.PERIODSTARTTIME IS '周期开始时间';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.PERIODENDTIME IS '周期结束时间';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.ISDELETED IS '是否删除 0:否 1:是';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.CREATETIME IS '创建时间';
COMMENT ON COLUMN RFD_FMS.PIXIU_UP_REPORT_BASEINFO.UPDATETIME IS '更新时间';


CREATE SYNONYM RFD_FMS_READ.PIXIU_UP_REPORT_BASEINFO FOR RFD_FMS.PIXIU_UP_REPORT_BASEINFO;
CREATE SYNONYM RFD_FMS_PROG.PIXIU_UP_REPORT_BASEINFO FOR RFD_FMS.PIXIU_UP_REPORT_BASEINFO;

GRANT DELETE,
      INSERT,
      SELECT,
      UPDATE
   ON RFD_FMS.PIXIU_UP_REPORT_BASEINFO
   TO RFD_FMS_PROG;
GRANT SELECT ON RFD_FMS.PIXIU_UP_REPORT_BASEINFO TO RFD_FMS_READ;
GRANT SELECT ON RFD_FMS.PIXIU_UP_REPORT_BASEINFO TO RFD_DEV_RL;

CREATE SEQUENCE RFD_FMS.PIXIU_UP_REPORT_BASEINFO_SEQ MINVALUE 1
                                              MAXVALUE 9999999999999999999999999999
                                              START WITH 1
                                              INCREMENT BY 1
                                              CACHE 20;
											  
CREATE SYNONYM RFD_FMS_READ.PIXIU_UP_REPORT_BASEINFO_SEQ FOR RFD_FMS.PIXIU_UP_REPORT_BASEINFO_SEQ;
CREATE SYNONYM RFD_FMS_PROG.PIXIU_UP_REPORT_BASEINFO_SEQ FOR RFD_FMS.PIXIU_UP_REPORT_BASEINFO_SEQ;

GRANT SELECT ON RFD_FMS.PIXIU_UP_REPORT_BASEINFO_SEQ TO RFD_FMS_PROG;
GRANT SELECT ON RFD_FMS.PIXIU_UP_REPORT_BASEINFO_SEQ TO RFD_FMS_READ;
GRANT SELECT ON RFD_FMS.PIXIU_UP_REPORT_BASEINFO_SEQ TO RFD_DEV_RL;	

ALTER TABLE RFD_FMS.PIXIU_UP_REPORT_BASEINFO ADD (
  CONSTRAINT PK_PIXIU_UP_REPORT_BASEINFO
  PRIMARY KEY  (ID)
  USING INDEX LOCAL
  ENABLE VALIDATE);