desktop_task_schedule/code/db/建表/车非每日保费临时表.sql

drop table 车非每日保费_T;
create global temporary table 车非每日保费_T
(
  签单日期     DATE not null,
  月份       VARCHAR2(10) not null,
  部门       VARCHAR2(100) not null,
  部门代码   varchar2(100) not null,
  科室n      VARCHAR2(100) not null,
  经办人n     VARCHAR2(100),
  坐席工号     VARCHAR2(20),
  坐席名称     VARCHAR2(30),
  坐席团队     VARCHAR2(100),
  车险个人客户保费 NUMBER(16,2),
  车非融合保费   NUMBER(16,2)
)
on commit preserve rows;
-- Grant/Revoke object privileges 
grant select, insert, delete, alter on 车非每日保费_T to DATACENTER;