I'm after a way to create an oracle view that will list the dates in YYYY-MM-DD format of the previous month.
I need this to be dynamic enough so each time I select the view it will give me an updated list. All dates of June for example if I select the view in July.
Is this possible? say by selecting from the table dual?