/SQL/Sql calculate working days between two dates excluding weekends and holidays

Sql calculate working days between two dates excluding weekends and holidays

-- All dates between 01/07/2021 and 15/07/2021 excluding weekends
SELECT CAL_DATE
FROM (
         SELECT to_date('01/07/2021', 'DD/MM/YYYY') + ROWNUM - 1 AS CAL_DATE
         FROM ALL_OBJECTS
         WHERE ROWNUM <= to_date('15/07/2021', 'DD/MM/YYYY') 
                             - to_date('01/07/2021', 'DD/MM/YYYY') + 1)
WHERE to_char(CAL_DATE, 'DY', 'NLS_DATE_LANGUAGE=AMERICAN') NOT IN ('SAT', 'SUN');

Similar codes

0 vote328 views1 answer
Difference between cross apply and inner join
SQL
0 vote339 views1 answer
Mysql get 2nd value in comma separated list
SQL
5 votes368 views1 answer
Mysql count newlines in field
SQL
10 votes344 views2 answers
Forgot my mysql password mac
SQL
7 votes356 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote335 views1 answer
Except in sql alchemy
SQL
3 votes355 views2 answers
Sql asc
SQL
12 votes352 views4 answers
Mysql ifnull
SQL
8 votes349 views3 answers
Alter table auto_increment
SQL
0 vote338 views1 answer
Sub blocks in sql
SQL