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

13 votes185 views2 answers
Check if value is null mysql
SQL
0 vote196 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
6 votes2.2K views1 answer
Sql select second max
SQL
0 vote253 views1 answer
Check user sql password from command line
SQL
0 vote191 views1 answer
Postgresql comandos basicos
SQL
0 vote196 views1 answer
Mysql page segment
SQL
2 votes176 views1 answer
How to delete columns in sql
SQL
0 vote196 views1 answer
Désinstaller postgresql linux
SQL
6 votes189 views1 answer
Phpmyadmin password root
SQL
0 vote210 views1 answer
Connect to ssms with python
SQL