使用Oracle的SQL函数实现工作日和节假日分组统计

Application of grouping statistic of working day and holiday through functions of SQL in Oracle

目的:按工作日和节假日分别进行工作量统计,有助于合理调度人力物力资源,合理制定节假日劳务补贴措施。方法:通过Oracle的SQL函数实现工作日和节假日的判断方法。结果:能够方便地完成工作日、节假日工作量统计。结论:节假日工作量统计越来越成为常规统计内容,将其单独分析具有实用价值。

Objective To calculate workload according to working day and holiday separately, Methods Functions of SQL in Oracle were used to separate working day and holiday. Results The method could accomplish holiday＇s workload statistics expediently. Conclusions Statistics of holiday＇s workload are becoming ordinary work, so the separated analysis for them has practical value.