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

19 lines
623 B
MySQL
Raw Permalink Normal View History

2023-08-15 01:51:54 +00:00
drop table _T;
create global temporary table _T
2023-05-09 12:24:37 +00:00
(
2023-08-15 01:51:54 +00:00
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)
2023-05-09 12:24:37 +00:00
)
on commit preserve rows;
-- Grant/Revoke object privileges
2023-08-15 01:51:54 +00:00
grant select, insert, delete, alter on _T to DATACENTER;