/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

-1 vote179 views1 answer
Mysql delete duplicate rows except one
SQL
1 vote154 views1 answer
Table information in sql server
SQL
1 vote225 views1 answer
Mysql is odd
SQL
13 votes146 views2 answers
Sql count distinct group by
SQL
0 vote105 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
9 votes147 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote153 views2 answers
Mysql update two tables at once
SQL
1 vote154 views1 answer
Drush sql-dump
SQL
0 vote150 views1 answer
Mysql match in serialized data
SQL
1 vote213 views1 answer
Connect to mysql database ubuntu
SQL