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 vote134 views1 answer
Isnull in sqlite
SQL
1 vote113 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
3 votes91 views2 answers
Pl sql escape '
SQL
1 vote105 views1 answer
Generate random data postgresql
SQL
0 vote123 views1 answer
Provera dupliranih konatakata
SQL
16 votes116 views1 answer
Mysql smallint range
SQL
0 vote100 views1 answer
Postgres copy command
SQL
3 votes126 views3 answers
List columns in table postgres
SQL
0 vote102 views1 answer
Get current date data in mysql
SQL
0 vote113 views1 answer
Learnxinyminutes sql
SQL