Connect by to generate rows

I just want to clarify something today : I do not like the connect by level select * from dual connect by level select * from dual connect by level

Put your code in <code> and </code> tags

4 Responses to “Connect by to generate rows”

  1. Duke Ganote Says:

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

  2. laurent schneider Says:

    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

  3. Anonymous Says:

    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.

  4. Laurent Schneider Says:

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

Leave a Reply

Use <code> and </code> to post code