/SQL/How to get all dates in a month in oracle

How to get all dates in a month in oracle

-- 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

23 votes99 views3 answers
Mysqldump
SQL
0 vote134 views1 answer
Postgresql if else endif
SQL
1 vote127 views1 answer
Sql server find tables referenced foreign key
SQL
0 vote129 views1 answer
Mysql to get column name in database
SQL
0 vote138 views1 answer
Oracle execute package dblink
SQL
0 vote146 views1 answer
Str_to_date sql server
SQL
0 vote117 views1 answer
Export partttion and import in oracle
SQL
0 vote109 views2 answers
Postgresql display subquery as json
SQL
0 vote135 views1 answer
Postgresql not in alternative
SQL
4 votes141 views1 answer
Sql data types
SQL