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 vote230 views1 answer
Sql constarint
SQL
1 vote211 views1 answer
Mysql query bulk insert
SQL
1 vote230 views1 answer
Mysql take number in string
SQL
4 votes190 views1 answer
Oracle show errors compilation
SQL
1 vote239 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
1 vote210 views1 answer
How to start with sql
SQL
0 vote201 views2 answers
2nd max salary query in sql
SQL
0 vote249 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote202 views2 answers
Mysql disable foreign key checks
SQL
0 vote218 views1 answer
Day of the week sqlite
SQL