/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

5 votes324 views1 answer
How to check nls format in oracle
SQL
0 vote321 views1 answer
Data types mysql vs postgresql
SQL
4 votes392 views2 answers
Sql display today's date
SQL
0 vote329 views1 answer
Sql server remove enter from string
SQL
1 vote323 views1 answer
How to check the mysql version mac
SQL
2 votes306 views1 answer
Match in sql server
SQL
4 votes337 views2 answers
REST API
SQL
0 vote304 views1 answer
What does the -p flag do in mysql cli
SQL
-1 vote343 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
0 vote323 views2 answers
How to get json data mysql
SQL