Oracle list days between two dates

-- 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 vote434 views1 answer
How to subquey to do not load in live database in
SQL
0 vote281 views2 answers
Jupyter notebook connect to database
SQL
9 votes343 views2 answers
Cmd to rename a collumn name in sql
SQL
4 votes357 views2 answers
Mysql delete user if exists
SQL
0 vote339 views1 answer
Sql comand for removing data from table
SQL
0 vote373 views1 answer
Contraint default SQL
SQL
34 votes405 views6 answers
Alter table add foreign key mysql
SQL
0 vote337 views1 answer
Sql create text column limited values
SQL
0 vote345 views1 answer
Oracle dynamic select into
SQL
0 vote356 views2 answers
Postgres default user
SQL