Statement showing the date of each day of a month

The statement that shows the date of each day of a month meets the customer's requirements today. The data of each day of each month should be displayed even if there is no data on that day. The customer's needs are a wonderful effect, but it is these wonders that improve their skills: the code is as follows: select to_char (to_date ('& month', 'yyymmm') + (rownum-1), 'dd ') DAY_IDfrom dual www.2cto.com connect by rownum <= to_number (to_char (last_day (to_date ('& month', 'yyyymm'), 'dd') by duanning397