/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 vote138 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
1 vote155 views1 answer
Autocommit mysql
SQL
0 vote157 views1 answer
Copy row from db to db mysql
SQL
29 votes127 views5 answers
Mysql show table structure
SQL
0 vote127 views2 answers
Update information in a mysql column
SQL
6 votes228 views3 answers
Psql show columns of table
SQL
2 votes125 views4 answers
Duplicate record mysql
SQL
-1 vote133 views1 answer
How to open blade file from blade in laravel
SQL
0 vote135 views1 answer
Search db for table name
SQL
11 votes126 views3 answers
How to get last row of table in sql
SQL