/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 vote152 views1 answer
Command to give readonly access to a postgres sql user
SQL
1 vote136 views1 answer
Postgres regex remove special characters
SQL
0 vote123 views1 answer
Oracle activate program
SQL
0 vote130 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote146 views1 answer
Hallo
SQL
0 vote149 views1 answer
Command line mysql xampp
SQL
3 votes133 views2 answers
Postgres show table schema
SQL
1 vote181 views1 answer
SQL server query column yes or no
SQL
0 vote122 views1 answer
Date diff sql
SQL
0 vote150 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL