2018 工作日节假日字典表

版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/huryer/article/details/83084860

2018 工作日节假日字典表

基于oracle数据库的2018年度工作日,节假日字典表;

create table WorkingCalendar(
rq date,
week number(1),
is_work_day number(1),
note varchar2(10),
constraint pk_WorkingCalendar primary key(rq)
)
;

comment on column WorkingCalendar.Rq is '日期';
comment on column WorkingCalendar.week is '星期';
comment on column WorkingCalendar.is_work_day is '是否工作日(0:节假日或周六日,1:工作日)';
comment on column WorkingCalendar.note is '备注';

select * from WorkingCalendar;

insert into WorkingCalendar values (to_date('2018-01-01','yyyy-mm-dd'), 1, 0, '元旦');
insert into WorkingCalendar values (to_date('2018-01-02','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-01-03','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-01-04','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-01-05','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-01-06','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-01-07','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-01-08','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-01-09','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-01-10','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-01-11','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-01-12','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-01-13','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-01-14','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-01-15','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-01-16','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-01-17','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-01-18','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-01-19','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-01-20','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-01-21','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-01-22','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-01-23','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-01-24','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-01-25','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-01-26','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-01-27','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-01-28','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-01-29','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-01-30','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-01-31','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-02-01','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-02-02','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-02-03','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-02-04','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-02-05','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-02-06','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-02-07','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-02-08','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-02-09','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-02-10','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-02-11','yyyy-mm-dd'), 7, 1, '');
insert into WorkingCalendar values (to_date('2018-02-12','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-02-13','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-02-15','yyyy-mm-dd'), 4, 0, '春节');
insert into WorkingCalendar values (to_date('2018-02-16','yyyy-mm-dd'), 5, 0, '春节');
insert into WorkingCalendar values (to_date('2018-02-17','yyyy-mm-dd'), 6, 0, '春节');
insert into WorkingCalendar values (to_date('2018-02-18','yyyy-mm-dd'), 7, 0, '春节');
insert into WorkingCalendar values (to_date('2018-02-19','yyyy-mm-dd'), 1, 0, '春节');
insert into WorkingCalendar values (to_date('2018-02-20','yyyy-mm-dd'), 2, 0, '春节');
insert into WorkingCalendar values (to_date('2018-02-21','yyyy-mm-dd'), 3, 0, '春节');
insert into WorkingCalendar values (to_date('2018-02-22','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-02-23','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-02-24','yyyy-mm-dd'), 6, 1, '');
insert into WorkingCalendar values (to_date('2018-02-25','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-02-26','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-02-27','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-02-28','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-03-01','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-03-02','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-03-03','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-03-04','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-03-05','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-03-06','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-03-07','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-03-08','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-03-09','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-03-10','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-03-11','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-03-12','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-03-13','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-03-14','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-03-15','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-03-16','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-03-17','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-03-18','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-03-19','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-03-20','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-03-21','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-03-22','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-03-23','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-03-24','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-03-25','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-03-26','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-03-27','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-03-28','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-03-29','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-03-31','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-04-01','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-04-02','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-04-03','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-04-04','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-04-05','yyyy-mm-dd'), 4, 0, '清明节');
insert into WorkingCalendar values (to_date('2018-04-06','yyyy-mm-dd'), 5, 0, '清明节');
insert into WorkingCalendar values (to_date('2018-04-07','yyyy-mm-dd'), 6, 0, '清明节');
insert into WorkingCalendar values (to_date('2018-04-08','yyyy-mm-dd'), 7, 1, '');
insert into WorkingCalendar values (to_date('2018-04-09','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-04-10','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-04-11','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-04-12','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-04-13','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-04-14','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-04-15','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-04-16','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-04-17','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-04-18','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-04-19','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-04-20','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-04-21','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-04-22','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-04-23','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-04-24','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-04-25','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-04-26','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-04-27','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-04-28','yyyy-mm-dd'), 6, 1, '');
insert into WorkingCalendar values (to_date('2018-04-29','yyyy-mm-dd'), 7, 0, '五一');
insert into WorkingCalendar values (to_date('2018-04-30','yyyy-mm-dd'), 1, 0, '五一');
insert into WorkingCalendar values (to_date('2018-05-01','yyyy-mm-dd'), 2, 0, '五一');
insert into WorkingCalendar values (to_date('2018-05-02','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-05-03','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-05-04','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-05-05','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-05-06','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-05-07','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-05-08','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-05-09','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-05-10','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-05-11','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-05-12','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-05-14','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-05-15','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-05-16','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-05-17','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-05-18','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-05-19','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-05-20','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-05-21','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-05-22','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-05-23','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-05-24','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-05-25','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-05-26','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-05-27','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-05-28','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-05-29','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-05-30','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-05-31','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-06-01','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-06-02','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-06-03','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-06-04','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-06-05','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-06-06','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-06-07','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-06-08','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-06-09','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-06-10','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-06-11','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-06-12','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-06-13','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-06-14','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-06-15','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-06-16','yyyy-mm-dd'), 6, 0, '端午节');
insert into WorkingCalendar values (to_date('2018-06-17','yyyy-mm-dd'), 7, 0, '端午节');
insert into WorkingCalendar values (to_date('2018-06-18','yyyy-mm-dd'), 1, 0, '端午节');
insert into WorkingCalendar values (to_date('2018-06-19','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-06-20','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-06-21','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-06-22','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-06-23','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-06-24','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-06-25','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-06-27','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-06-28','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-06-29','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-06-30','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-07-01','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-07-02','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-07-03','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-07-04','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-07-05','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-07-06','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-07-07','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-07-08','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-07-09','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-07-10','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-07-11','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-07-12','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-07-13','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-07-14','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-07-15','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-07-16','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-07-17','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-07-18','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-07-19','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-07-20','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-07-21','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-07-22','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-07-23','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-07-24','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-07-25','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-07-26','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-07-27','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-07-28','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-07-29','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-07-30','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-07-31','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-08-01','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-08-02','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-08-03','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-08-04','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-08-05','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-08-06','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-08-07','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-08-08','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-08-10','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-08-11','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-08-12','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-08-13','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-08-14','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-08-15','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-08-16','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-08-17','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-08-18','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-08-19','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-08-20','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-08-21','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-08-22','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-08-23','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-08-24','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-08-25','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-08-26','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-08-27','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-08-28','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-08-29','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-08-30','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-08-31','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-09-01','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-09-02','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-09-03','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-09-04','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-09-05','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-09-06','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-09-07','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-09-08','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-09-09','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-09-10','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-09-11','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-09-12','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-09-13','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-09-14','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-09-15','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-09-16','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-09-17','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-09-18','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-09-19','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-09-20','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-09-21','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-09-22','yyyy-mm-dd'), 6, 0, '中秋节');
insert into WorkingCalendar values (to_date('2018-09-23','yyyy-mm-dd'), 7, 0, '中秋节');
insert into WorkingCalendar values (to_date('2018-09-24','yyyy-mm-dd'), 1, 0, '中秋节');
insert into WorkingCalendar values (to_date('2018-09-25','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-09-26','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-09-27','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-09-28','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-09-29','yyyy-mm-dd'), 6, 1, '');
insert into WorkingCalendar values (to_date('2018-09-30','yyyy-mm-dd'), 7, 1, '');
insert into WorkingCalendar values (to_date('2018-10-01','yyyy-mm-dd'), 1, 0, '国庆');
insert into WorkingCalendar values (to_date('2018-10-02','yyyy-mm-dd'), 2, 0, '国庆');
insert into WorkingCalendar values (to_date('2018-10-03','yyyy-mm-dd'), 3, 0, '国庆');
insert into WorkingCalendar values (to_date('2018-10-04','yyyy-mm-dd'), 4, 0, '国庆');
insert into WorkingCalendar values (to_date('2018-10-05','yyyy-mm-dd'), 5, 0, '国庆');
insert into WorkingCalendar values (to_date('2018-10-06','yyyy-mm-dd'), 6, 0, '国庆');
insert into WorkingCalendar values (to_date('2018-10-07','yyyy-mm-dd'), 7, 0, '国庆');
insert into WorkingCalendar values (to_date('2018-10-08','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-10-09','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-10-10','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-10-11','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-10-12','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-10-13','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-10-14','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-10-15','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-10-16','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-10-17','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-10-18','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-10-19','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-10-20','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-10-21','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-10-22','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-10-23','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-10-24','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-10-25','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-10-26','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-10-27','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-10-28','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-10-29','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-10-30','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-10-31','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-11-01','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-11-02','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-11-03','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-11-04','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-11-06','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-11-07','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-11-08','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-11-09','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-11-10','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-11-11','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-11-12','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-11-13','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-11-14','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-11-15','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-11-16','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-11-17','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-11-18','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-11-19','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-11-20','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-11-21','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-11-22','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-11-23','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-11-24','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-11-25','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-11-26','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-11-27','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-11-28','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-11-29','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-11-30','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-12-01','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-12-02','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-12-03','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-12-04','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-12-05','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-12-06','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-12-07','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-12-08','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-12-09','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-12-10','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-12-11','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-12-12','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-12-13','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-12-14','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-12-15','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-12-16','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-12-17','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-12-18','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-12-20','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-12-21','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-12-22','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-12-23','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-12-24','yyyy-mm-dd'), 1, 1, '');
insert into WorkingCalendar values (to_date('2018-12-25','yyyy-mm-dd'), 2, 1, '');
insert into WorkingCalendar values (to_date('2018-12-26','yyyy-mm-dd'), 3, 1, '');
insert into WorkingCalendar values (to_date('2018-12-27','yyyy-mm-dd'), 4, 1, '');
insert into WorkingCalendar values (to_date('2018-12-28','yyyy-mm-dd'), 5, 1, '');
insert into WorkingCalendar values (to_date('2018-12-29','yyyy-mm-dd'), 6, 0, '');
insert into WorkingCalendar values (to_date('2018-12-30','yyyy-mm-dd'), 7, 0, '');
insert into WorkingCalendar values (to_date('2018-12-31','yyyy-mm-dd'), 1, 1, '');
commit;
阅读更多
换一批

没有更多推荐了,返回首页