CREATE TABLE COPY_T

AS

SELECT A.LV AS DUP_NO, B.LV AS NO

FROM (SELECT LEVEL LV

      FROM DUAL

      CONNECT BY LEVEL <= 200

      ) A

    INNER JOIN (SELECT LEVEL LV

                FROM DUAL

                CONNECT BY LEVEL <= 200

                ) B

        ON A.LV >= B.LV

+ Recent posts