Application of grouping statistic of working day and holiday through functions of SQL in Oracle
- VernacularTitle:使用Oracle的SQL函数实现工作日和节假日分组统计
- Author:
Xiutang CAO
;
Wei DAI
;
Hu HU
;
Jun GAO
;
Lu HAO
- Publication Type:Journal Article
- Keywords:
holiday;
working day;
SQL
- From:
Chinese Medical Equipment Journal
2003;0(11):-
- CountryChina
- Language:Chinese
-
Abstract:
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.