Laurent Schneider

For what it’s worth, I concur with your assessment of “DUAL CONNECT BY LEVEL

note that in production, I would recommend creating “lookup” tables if appropriate.

For datawarehouse, prefer using dimension tables, as described in the
datawarehouse guide
, if I need to outer join with each day of the year, or each minute, I create the relevant table and insert each values than join with that fix table. It can be partitioned, or IOT, and it is highly scalable.

Generating the rows is not “better” than using a fixed lookup table. Check what is the most appropriate.

thanks for your comment, I greatly appreciate

Sali Laurent hope you yre doing fine. Your profile is at moment not complete. So it is a bit difficult to accuit you.

Thanks Ben.

Thanks ben for your comment.
What is missing in my profile?