-- 로또645 --
SELECT rnum
     , MIN(DECODE(rn, 1, v)) n1
     , MIN(DECODE(rn, 2, v)) n2
     , MIN(DECODE(rn, 3, v)) n3
     , MIN(DECODE(rn, 4, v)) n4
     , MIN(DECODE(rn, 5, v)) n5
     , MIN(DECODE(rn, 6, v)) n6
     , MIN(DECODE(rn, 7, v)) n7
  FROM (SELECT rnum, v
             , ROW_NUMBER() OVER(PARTITION BY rnum ORDER BY DECODE(rn, 7, 99, v)) rn
          FROM (SELECT CEIL(LEVEL/45) rnum
                     , MOD(LEVEL-1, 45)+1 v
                     , ROW_NUMBER() OVER(PARTITION BY CEIL(LEVEL/45)
                                             ORDER BY dbms_random.value) rn
                  FROM dual
                 CONNECT BY LEVEL <= 45 * 5
                )
         WHERE rn <= 7
        )
 GROUP BY rnum
 ORDER BY rnum
;