Why do you want to stick with dual? Dual has only one row, so it can return you only one date. You need a table or view that has at least so many rows as the dates you want to display. So what is wrong with the sollution with ALL_OBJECTS (or some similar publicly accesible view/table)? It is accesible to every user, the same way the DUAL.