dual构建临时数据集以及动态生成临时表

 

 select case num
        WHEN 0 THEN 'a'
        WHEN 1 THEN 'd'
        WHEN 2 THEN 'b'
        WHEN 3 THEN '强制报废'
        WHEN 4 THEN 'c'
        ELSE '' END LXMC,
        num as clqk
   from (SELECT ROWNUM -1 as  num FROM DUAL CONNECT BY LEVEL <= 5)

//动态生成临时表

CREATE GLOBAL TEMPORARY TABLE TABLENAME ON COMMIT PRESERVE ROWS as select * from others_table