ORACLE临时表，产生一个类似于MST表

一、

SELECT CASE WHEN ROWNUM<10 THEN ROWNUM
            WHEN ROWNUM=10 THEN 100
       END AS "区分",
       CASE WHEN ROWNUM = 1 THEN 'A'
            WHEN ROWNUM = 2 THEN 'B'
            WHEN ROWNUM = 3 THEN 'C'
            WHEN ROWNUM = 4 THEN 'D'
            WHEN ROWNUM = 5 THEN 'E'
            WHEN ROWNUM = 6 THEN 'F'
            WHEN ROWNUM = 7 THEN 'G'
            WHEN ROWNUM = 8 THEN 'H'
            WHEN ROWNUM = 9 THEN 'I'
            WHEN ROWNUM = 10 THEN 'Z'
       END AS "区分名"
  FROM DUAL
CONNECT BY LEVEL <= 10

结果：

　区分　区分名
　1           A
    2           B
    3           C

    4           D
    5           E
    6           F
    7           G
    8           H
    9           I
    100       Z

 

 

二、

SELECT ROWNUM AS "区分",
       (CASE ROWNUM 
             WHEN 1 THEN 'A'
             WHEN 2 THEN 'B'
             WHEN 3 THEN 'C'
             WHEN 4 THEN 'D'
             WHEN 5 THEN 'E'
             WHEN 6 THEN 'F'
             WHEN 7 THEN 'G'
        END) AS "区分名"
FROM DUAL
CONNECT BY LEVEL <= 7

 

结果

　区分　区分名
　1           A
    2           B
    3           C

    4           D
    5           E
    6           F
    7           G