/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

0 vote174 views1 answer
Mariadb cast null to 0
SQL
0 vote204 views1 answer
Delete a temporary table mysql
SQL
1 vote170 views1 answer
Apex ORA-20999
SQL
2 votes160 views1 answer
Oracle run_duration average
SQL
0 vote164 views1 answer
Postgres call view
SQL
2 votes224 views5 answers
Install postgresql 10 centos 7
SQL
14 votes171 views3 answers
Alter foreign key
SQL
-1 vote197 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
1 vote175 views2 answers
Postgresql backup and restore globals and data
SQL
0 vote281 views1 answer
Python get backup of sql
SQL