/SQL/Oracle generate list of dates in between a date range

Oracle generate list of dates in between a date range

-- All dates between 01/01/2021 and 15/01/2021
SELECT to_date('01/01/2021', 'DD/MM/YYYY') + ROWNUM - 1
FROM ALL_OBJECTS
WHERE ROWNUM <= to_date('15/01/2021', 'DD/MM/YYYY') 
	- to_date('01/01/2021', 'DD/MM/YYYY') + 1;

Similar codes

1 vote376 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
6 votes350 views2 answers
Join vs union
SQL
1 vote392 views1 answer
Base64 encode sql server
SQL
2 votes359 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote373 views1 answer
Capabilities of sql select statements
SQL
0 vote332 views1 answer
How to remove default in mysql
SQL
7 votes366 views1 answer
Return insert results in POSTGRESQL
SQL
0 vote375 views1 answer
Add timestamp column to existing table t-sql
SQL
2 votes386 views2 answers
Spring import sql
SQL
1 vote365 views1 answer
Where database run
SQL