/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 vote283 views1 answer
How to define a non primary composite key in sql
SQL
8 votes270 views2 answers
Grant all privileges database postgres to user
SQL
1 vote269 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
0 vote269 views1 answer
Mysql where in keep order
SQL
4 votes286 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote287 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote298 views1 answer
Yesql
SQL
9 votes284 views2 answers
Nosql databases
SQL
3 votes294 views5 answers
Sql select
SQL
-1 vote297 views2 answers
Sql search all tables for attributes
SQL