/SQL/How to calculate number of days between two dates excluding weekends in oracle

How to calculate number of days between two dates excluding weekends in oracle

-- 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 vote114 views1 answer
Postgresql create table default value timestamp
SQL
0 vote121 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
3 votes121 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
0 vote126 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
5 votes121 views1 answer
Oracle nls session
SQL
0 vote108 views1 answer
Increment id in mysql
SQL
6 votes130 views3 answers
What is where in sql
SQL
0 vote139 views1 answer
Using distinct and count together in sql
SQL
0 vote121 views1 answer
How to find date from date table in sql
SQL
0 vote113 views4 answers
Best data type to represent money in mysql
SQL