Oracle list dates without weekends

-- 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 vote143 views1 answer
Mysql enter ubuntu
SQL
3 votes147 views2 answers
Sqlite show table definition
SQL
0 vote136 views1 answer
Mysql set boolean default value
SQL
0 vote150 views1 answer
A network or instance-specific error sql server
SQL
6 votes135 views1 answer
Postgresql add enum value
SQL
1 vote130 views1 answer
Moodle query first user access
SQL
0 vote145 views2 answers
Select last 30 days sql
SQL
0 vote137 views1 answer
Influxdb clone measurement
SQL
0 vote152 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
-1 vote138 views1 answer
How to reset autoincrement in sqlite java
SQL