/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 vote99 views1 answer
Update set with join pl sql
SQL
2 votes133 views2 answers
Get all tables using like
SQL
2 votes136 views1 answer
Q operator in plsql
SQL
0 vote144 views1 answer
Date on SQL
SQL
0 vote142 views1 answer
Use mysql in java program
SQL
0 vote138 views1 answer
Jenkins SQLCMD run
SQL
0 vote139 views1 answer
Enable full text search mysql
SQL
0 vote145 views1 answer
Plsql check how much space all databases are consuming
SQL
0 vote135 views1 answer
Mysql identified by syntax error
SQL
0 vote147 views1 answer
Trigger stock phpmyadmin output message
SQL