/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 vote125 views1 answer
Grant access on table in oracle
SQL
1 vote116 views1 answer
Login to database mysql terminal
SQL
0 vote118 views1 answer
Grepper sql workbench download
SQL
1 vote119 views1 answer
Truncate left characters mysql
SQL
2 votes124 views2 answers
Spring where to put the data sql
SQL
0 vote122 views1 answer
Normalization in database 2nd normal form
SQL
0 vote121 views1 answer
Sql get user account
SQL
0 vote77 views1 answer
Bigquery information_schema schema all columns
SQL
1 vote116 views1 answer
Postgres first_value in gropby
SQL
12 votes149 views1 answer
Create column sql server
SQL