데이터/Oracle
복제용 테이블 생성
RareOne
2018. 11. 7. 16:29
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