ORACLE阶层

方法1：
DECLARE
    o     NUMBER;
    str   VARCHAR(1000);
BEGIN
    str := 'WITH
NT AS (SELECT LEVEL L FROM DUAL CONNECT BY LEVEL <= 10)
SELECT '
     || chr(39)
     || 'SELECT '
     || chr(39)
     || '||LISTAGG(L,'
     || chr(39)
     || '*'
     || chr(39)
     || ') WITHIN GROUP (ORDER BY L ) || '
     || chr(39)
     || ' FROM DUAL '
     || chr(39)
     || '  FROM NT  ';

   -- dbms_output.put_line(str);

    EXECUTE IMMEDIATE str INTO
        str;
    EXECUTE IMMEDIATE str INTO
        o;
    dbms_output.put_line(o || '===' || o);
END;

方法2：
with c(n,m) as
(select 1,1 m from dual
union all
select n+1 ,m*n m from c
where n <= 10 )
select max(m) c from c;