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
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