PL_SQL生成双色球所有组合

CREATE TABLE T_SSQ(
RED1 NUMBER,
RED2 NUMBER,
RED3 NUMBER,
RED4 NUMBER,
RED5 NUMBER,
RED6 NUMBER,
BLUE7 NUMBER
)


DECLARE

  --CNT INTEGER := 0;
  --红球组合 c33/6=33*32*31*30*29*28/6*5*4*3*2*1=1107568
  --有16个篮球所以乘16
  --所以一共组合数即1107568*16=17721088种组合！

BEGIN

  FOR IP1 IN 1 .. 28 LOOP
    --IP1
  
    FOR IP2 IN IP1 + 1 .. 29 LOOP
      --IP2
    
      FOR IP3 IN IP2 + 1 .. 30 LOOP
        --IP3