/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

3 votes310 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote271 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
3 votes260 views2 answers
How to View column names of a table in SQL
SQL
2 votes252 views1 answer
Sql find missing values between two tables
SQL
0 vote286 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote278 views1 answer
Mysql persistence.xml
SQL
2 votes267 views1 answer
How to add where command in update comand with joins
SQL
0 vote292 views1 answer
Example database query
SQL
0 vote287 views1 answer
Insert ip address in mysql
SQL
0 vote275 views1 answer
St_buffer mysql
SQL