2024年日历excel和Oracle新增sql（标记上班日，周末，节假日）

--建表sql create table T_HOLIDAY_WEEK ( id VARCHAR2(50) default sys_guid() not null, day_date VARCHAR2(20), day_typ VARCHAR2(10) ) comment on table T_HOLIDAY_WEEK is '2024年节假日周末表'; -- Add comments to the columns comment on column T_HOLIDAY_WEEK.id is '主键'; comment on column T_HOLIDAY_WEEK.day_date is '日期'; comment on column T_HOLIDAY_WEEK.day_typ is '日期类型，0：工作日 1：周末 2：节假日'; --新增sql insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('7BFF96B6DFFB4E44826D649FC64BCECE', '2024-01-01', '2'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('778DCA3ECC994471985C70E70DE3E560', '2024-01-02', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('56E621CD183645E8B9DC7A9A0116224D', '2024-01-03', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('310F5E3F6835481291768F40B6CEC9ED', '2024-01-04', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('E446B064C92C40E2BDC4937A1C7FC0C6', '2024-01-05', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('691D43E3B0224F8A8DEE1B56BE3E505B', '2024-01-06', '1'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('243DC881277F431B964FEEB1F11BBCFA', '2024-01-07', '1'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('8203CB3E33274BD3AB1524710E53DFE4', '2024-01-08', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('D698797634C74C199126CA2C652941C5', '2024-01-09', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('4AF1FFEFC5FF46A483D482CF3E3A3700', '2024-01-10', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('E90ED80200CC4F21934997A4498A1A4C', '2024-01-11', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('B922E3AEE41B43FCAB0481F5FCEDAD79', '2024-01-12', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('738036A08A4A420C9598EEB7B71B02D0', '2024-01-13', '1'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('AF4EAF9B1B1E4065A37FBBFA57EA9649', '2024-01-14', '1'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('E0AA14CF08754024B4FF171FE816519C', '2024-01-15', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('A605413562F446588E8E2F73C3488E20', '2024-01-16', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('CAFC1A6987CC464B98DE4DC6CBBBB40F', '2024-01-17', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('57ED80ADA7F949F3874FB86EEBD3B564', '2024-01-18', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('99A32FCB0BFC46B394001BAE763EF56C', '2024-01-19', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('9283FCF78C334EBF97E9C6C1C7CC2911', '2024-01-20', '1'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('06650ECDD1CF4FE393ACEAEDEBB1FA8A', '2024-01-21', '1'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('6896A953871340719185B9688B26758E', '2024-01-22', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('11B3C97B72F44771B53BE9353392581D', '2024-01-23', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('23586C0491E5441091749F9EB5DACC89', '2024-01-24', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('4BB614A59A76437B8485DE530B12A760', '2024-01-25', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('1CAC982409C741149145A863F73A4B07', '2024-01-26', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('D1299BADF76A4D8EB669F1157AB5858D', '2024-01-27', '1'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('3D144DF503D341E387E1A2B19966D7D9', '2024-01-28', '1'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('8210936E84DF4A2AB86105DABEDA7639', '2024-01-29', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('2CB8952377174B979F3AA4EC57C8C048', '2024-01-30', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('FB2FB1A99256428D91C2FD493DEB109D', '2024-01-31', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('E571795A63304A1CBCB255B77672CD96', '2024-02-01', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('A4DFDA8D10254EBD884481741AB77049', '2024-02-02', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('B36DC667F7EF47B7B499162A4F2994B7', '2024-02-03', '1'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('6A7A6B512F64405593500C6E514AD56E', '2024-02-04', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('D251B34135554BBF931277E063707DBD', '2024-02-05', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('25266BFFECB6434EBACBAA1047C8B669', '2024-02-06', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('5FD664179D76411D803D84F7765ACDBC', '2024-02-07', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('4D770C9D63294714A4B653AF15AE7C62', '2024-02-08', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('384111A61C3A49A08407E143AF0B7E4E', '2024-02-09', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('0AC37CD5D8AD41A08B65125E217537D4', '2024-02-10', '2'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('BA120A806A2E4DFAB899ED1A5122DEA3', '2024-02-11', '2'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('48CFC857861F4FA08ADBB75FD3BEE94D', '2024-02-12', '2'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('E8600FDD72E34D8C9F25A96B79369B6B', '2024-02-13', '2'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('8850990F80B34AFBAE18EDC42860E034', '2024-02-14', '2'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('91F18328DF344FC58FB9F4663AFB3BA3', '2024-02-15', '2'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('E988F3EEAA4248908808306B2F0C43B5', '2024-02-16', '2'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('936335CAB6DE4F71918D9066839039D4', '2024-02-17', '2'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('7245EE9C5C394CF3BB66F7B12335046A', '2024-02-18', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('E87687D1E1C2448086A9AD99984B3BB5', '2024-02-19', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('D495DD381AC245168E5AC5A368577CA7', '2024-02-20', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('39C5A79F11E44639BEC8DA993F6C4886', '2024-02-21', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('AAEF5687B07D478A9F929668F95702FF', '2024-02-22', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('6BE793F2CA454031A93BB4A7B282684E', '2024-02-23', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('C9BA85204615479D945DA4CED4D70BCA', '2024-02-24', '1'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('EE13987AF02C48CD980E06C4F417D2DF', '2024-02-25', '1'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('D9CE6B5259AF4854AC78C10B67EF9DC3', '2024-02-26', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('78A96D9E0D3241AC86D6BCCC1B9BB4DA', '2024-02-27', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('E3C647D8C92A4FC1807F89D68BB0D09D', '2024-02-28', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('19576742F14047E7885B9EC363AEEEFA', '2024-02-29', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('7C3CFA7B2AE54A328A53061D676B7CB5', '2024-03-01', '0'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('6D8E62E255424E56AE6F9713F3CE72CF', '2024-03-02', '1'); insert into T_HOLIDAY_WEEK (ID, DAY_DATE, DAY_TYP) values ('CA4DC1C31ACE493E9FF4F7762D1F32C0', '2024-03-03', '1');