« 10gR2 Grid Control is out!
Bible of Oracle »

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

This entry was posted on Friday, November 4th, 2005 at 08:58 and is filed under oracle, sql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Post to : del.icio.us - Digg it - Furl - reddit - Spurl

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

4 Responses to “Connect by to generate rows”

  1. Duke Ganote Says:
    November 17th, 2005 at 21:25

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

  2. laurent schneider Says:
    November 17th, 2005 at 22:59

    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:
    December 17th, 2005 at 13:01

    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:
    December 18th, 2005 at 08:20

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

Leave a Reply

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