/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

0 vote222 views1 answer
How to to get time in sql
SQL
0 vote191 views1 answer
Mysql workbench search all tables
SQL
0 vote220 views1 answer
How to write if case in select query in select statement
SQL
0 vote201 views1 answer
Oracle sql date summer time
SQL
6 votes251 views3 answers
Rename column ORACLE
SQL
1 vote226 views1 answer
Pl sql ptint
SQL
27 votes228 views3 answers
Mysql show tables in database
SQL
1 vote232 views2 answers
Snowflake alter column data type
SQL
0 vote210 views1 answer
AddEntityFrameworkSqlite
SQL
1 vote202 views1 answer
Sql exclude duplicates and find even id
SQL