/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

1 vote239 views1 answer
Oracle drop job if exists
SQL
3 votes240 views1 answer
Locate sql server
SQL
0 vote253 views1 answer
Postgresql print sessions using the database
SQL
7 votes235 views4 answers
What is my mysql version
SQL
2 votes253 views2 answers
Create empty table from existing table
SQL
0 vote236 views1 answer
Into operator in sql
SQL
1 vote235 views1 answer
How to see which columns are indexxed mysql
SQL
5 votes235 views4 answers
Mysql on duplicate key update
SQL
6 votes181 views2 answers
Generate c# class from sql server table
SQL
3 votes218 views1 answer
Search for column name in psql
SQL