꿈꾸는 개발자, DBA 커뮤니티 구루비

납품일자별 MIN 값 데이터 새로 올립니다!

by 홍길덩이 [PL/SQL] 오라클 [2019.04.17 10:20:15]

어제 맞지 않은 자료를 올려서 새로 올려 드립니다.

--원본

업체코드	아이템	아이템타입	작업주	아이템그룹	용량	납품일	작업구역
AP001-1	AT_20	1	1	AT	10	2019-04-01 0:00	A
AP001-2	AT_20	2	1	AT	20	2019-04-01 0:00	A
AP001-0	AT_20	0	2	AT	5	2019-04-02 0:00	A
AP003-1	AT_21	1	2	AT	18	2019-04-03 0:00	A
AP004-1	AT_22	1	2	AT	54	2019-04-02 0:00	C
AP005-1	AT_23	1	2	AT	8	2019-04-02 0:00	C
AP006-1	BA_20	1	2	BA	21	2019-04-02 0:00	A
AP007-1	BA_22	1	2	BA	41	2019-04-02 0:00	A
AP007-2	AT_22	2	2	AT	13	2019-04-04 0:00	A
AP007-3	AT_24	3	3	AT	1	2019-04-04 0:00	A
AP007-4	AT_25	4	3	AT	2	2019-04-04 0:00	A
AP001-1	AT_25	1	3	AT	3	2019-04-04 0:00	A
AP001-2	AT_26	2	3	AT	4	2019-04-04 0:00	A
AP002-1	AT_26	1	4	AT	7	2019-04-05 0:00	A
AP003-1	BA_27	1	4	BA	22	2019-04-05 0:00	A
AP004-1	AT_27	1	5	AT	26	2019-04-06 0:00	A
AP005-0	AT_28	0	5	AT	1	2019-04-07 0:00	A

--결과

업체코드	아이템	아이템타입	작업주	아이템그룹	용량	납품일	작업구역	순번
AP001-2	AT_20	2	1	AT	20	2019-04-01 0:00	A	1
AP001-1	AT_20	1	1	AT	10	2019-04-01 0:00	A	2
AP001-0	AT_20	0	2	AT	5	2019-04-02 0:00	A	3
AP004-1	AT_22	1	2	AT	54	2019-04-02 0:00	C	3
AP003-1	AT_21	1	2	AT	18	2019-04-03 0:00	A	4
AP005-1	AT_23	1	2	AT	8	2019-04-02 0:00	C	4
AP007-2	AT_22	2	2	AT	13	2019-04-04 0:00	A	5
AP007-1	BA_22	1	2	BA	41	2019-04-02 0:00	A	6
AP006-1	BA_20	1	2	BA	21	2019-04-02 0:00	A	7
AP001-2	AT_26	2	3	AT	4	2019-04-04 0:00	A	8
AP001-1	AT_25	1	3	AT	3	2019-04-04 0:00	A	9
AP007-3	AT_24	3	3	AT	1	2019-04-04 0:00	A	10
AP007-4	AT_25	4	3	AT	2	2019-04-04 0:00	A	11
AP002-1	AT_26	1	4	AT	7	2019-04-05 0:00	A	12
AP003-1	BA_27	1	4	BA	22	2019-04-05 0:00	A	13
AP004-1	AT_27	1	5	AT	26	2019-04-06 0:00	A	14
AP005-0	AT_28	0	5	AT	1	2019-04-07 0:00	A	15

--W_TIME

FROM_ITEM	TO_ITME	S_TIME
AT_20	AT_20	0
AT_20	AT_21	5
AT_20	AT_22	5
AT_20	AT_23	5
AT_20	AT_24	5
AT_20	AT_25	5
AT_20	AT_26	5
AT_20	AT_27	5
AT_20	AT_28	5
AT_20	BA_20	10
AT_20	BA_22	10
AT_20	BA_25	10
AT_20	BA_26	10
AT_20	BA_27	10
AT_21	AT_20	5
AT_21	AT_21	0
AT_21	AT_22	5
AT_21	AT_23	5
AT_21	AT_24	5
AT_21	AT_25	5
AT_21	AT_26	5
AT_21	AT_27	5
AT_21	AT_28	5
AT_21	BA_20	10
AT_21	BA_22	10
AT_21	BA_25	10
AT_21	BA_26	10
AT_21	BA_27	10
AT_22	AT_20	5
AT_22	AT_21	5
AT_22	AT_22	0
AT_22	AT_23	5
AT_22	AT_24	5
AT_22	AT_25	5
AT_22	AT_26	5
AT_22	AT_27	5
AT_22	AT_28	5
AT_22	BA_20	10
AT_22	BA_22	10
AT_22	BA_25	10
AT_22	BA_26	10
AT_22	BA_27	10
AT_23	AT_20	5
AT_23	AT_21	5
AT_23	AT_22	5
AT_23	AT_23	0
AT_23	AT_24	5
AT_23	AT_25	5
AT_23	AT_26	5
AT_23	AT_27	5
AT_23	AT_28	5
AT_23	BA_20	10
AT_23	BA_22	10
AT_23	BA_25	10
AT_23	BA_26	10
AT_23	BA_27	10
AT_24	AT_20	5
AT_24	AT_21	5
AT_24	AT_22	5
AT_24	AT_23	5
AT_24	AT_24	0
AT_24	AT_25	5
AT_24	AT_26	5
AT_24	AT_27	5
AT_24	AT_28	5
AT_24	BA_20	10
AT_24	BA_22	10
AT_24	BA_25	10
AT_24	BA_26	10
AT_24	BA_27	10
AT_25	AT_20	5
AT_25	AT_21	5
AT_25	AT_22	5
AT_25	AT_23	5
AT_25	AT_24	5
AT_25	AT_25	0
AT_25	AT_26	5
AT_25	AT_27	5
AT_25	AT_28	5
AT_25	BA_20	10
AT_25	BA_22	10
AT_25	BA_25	10
AT_25	BA_26	10
AT_25	BA_27	10
AT_26	AT_20	5
AT_26	AT_21	5
AT_26	AT_22	5
AT_26	AT_23	5
AT_26	AT_24	5
AT_26	AT_25	5
AT_26	AT_26	0
AT_26	AT_27	5
AT_26	AT_28	5
AT_26	BA_20	10
AT_26	BA_22	10
AT_26	BA_25	10
AT_26	BA_26	10
AT_26	BA_27	10
AT_27	AT_20	5
AT_27	AT_21	5
AT_27	AT_22	5
AT_27	AT_23	5
AT_27	AT_24	5
AT_27	AT_25	5
AT_27	AT_26	5
AT_27	AT_27	0
AT_27	AT_28	5
AT_27	BA_20	10
AT_27	BA_22	10
AT_27	BA_25	10
AT_27	BA_26	10
AT_27	BA_27	10
AT_28	AT_20	5
AT_28	AT_21	5
AT_28	AT_22	5
AT_28	AT_23	5
AT_28	AT_24	5
AT_28	AT_25	5
AT_28	AT_26	5
AT_28	AT_27	5
AT_28	AT_28	0
AT_28	BA_20	10
AT_28	BA_22	10
AT_28	BA_25	10
AT_28	BA_26	10
AT_28	BA_27	10
BA_20	AT_20	10
BA_20	AT_21	10
BA_20	AT_22	10
BA_20	AT_23	10
BA_20	AT_24	10
BA_20	AT_25	10
BA_20	AT_26	10
BA_20	AT_27	10
BA_20	AT_28	10
BA_20	BA_20	0
BA_20	BA_22	5
BA_20	BA_25	5
BA_20	BA_26	5
BA_20	BA_27	5
BA_22	AT_20	10
BA_22	AT_21	10
BA_22	AT_22	10
BA_22	AT_23	10
BA_22	AT_24	10
BA_22	AT_25	10
BA_22	AT_26	10
BA_22	AT_27	10
BA_22	AT_28	10
BA_22	BA_20	5
BA_22	BA_22	0
BA_22	BA_25	5
BA_22	BA_26	5
BA_22	BA_27	5
BA_25	AT_20	10
BA_25	AT_21	10
BA_25	AT_22	10
BA_25	AT_23	10
BA_25	AT_24	10
BA_25	AT_25	10
BA_25	AT_26	10
BA_25	AT_27	10
BA_25	AT_28	10
BA_25	BA_20	5
BA_25	BA_22	5
BA_25	BA_25	0
BA_25	BA_26	5
BA_25	BA_27	5
BA_26	AT_20	10
BA_26	AT_21	10
BA_26	AT_22	10
BA_26	AT_23	10
BA_26	AT_24	10
BA_26	AT_25	10
BA_26	AT_26	10
BA_26	AT_27	10
BA_26	AT_28	10
BA_26	BA_20	5
BA_26	BA_22	5
BA_26	BA_25	5
BA_26	BA_26	0
BA_26	BA_27	5
BA_27	AT_20	10
BA_27	AT_21	10
BA_27	AT_22	10
BA_27	AT_23	10
BA_27	AT_24	10
BA_27	AT_25	10
BA_27	AT_26	10
BA_27	AT_27	10
BA_27	AT_28	10
BA_27	BA_20	5
BA_27	BA_22	5
BA_27	BA_25	5
BA_27	BA_26	5
BA_27	BA_27	0

WITH W_NAME AS 
    (
    SELECT 'AP001-1' AS "업체코드", 'AT_20' AS "아이템", '1' AS "아이템타입", '1' AS "작업주", 'AT' AS "아이템그룹", 10 "용량", TO_DATE('20190401','YYYYMMDD') AS "납품일", 'A' AS "작업구역" FROM DUAL
    UNION ALL SELECT 'AP001-2', 'AT_20' AS "아이템", '2' AS "아이템타입", '1' AS "작업주", 'AT' AS "아이템그룹", 20 "용량", TO_DATE('20190401','YYYYMMDD'), 'A' AS "작업구역" FROM DUAL
    UNION ALL SELECT 'AP001-0', 'AT_20' AS "아이템", '0' AS "아이템타입", '2' AS "작업주", 'AT' AS "아이템그룹", 5 "용량", TO_DATE('20190402','YYYYMMDD'), 'A' AS "작업구역" FROM DUAL
    UNION ALL SELECT 'AP003-1', 'AT_21' AS "아이템", '1' AS "아이템타입", '2' AS "작업주", 'AT' AS "아이템그룹", 18 "용량", TO_DATE('20190403','YYYYMMDD'), 'A' AS "작업구역" FROM DUAL
    UNION ALL SELECT 'AP004-1', 'AT_22' AS "아이템", '1' AS "아이템타입", '2' AS "작업주", 'AT' AS "아이템그룹", 54 "용량", TO_DATE('20190402','YYYYMMDD'), 'C' AS "작업구역" FROM DUAL
    UNION ALL SELECT 'AP005-1', 'AT_23' AS "아이템", '1' AS "아이템타입", '2' AS "작업주", 'AT' AS "아이템그룹", 8 "용량", TO_DATE('20190402','YYYYMMDD'), 'C' AS "작업구역" FROM DUAL
    UNION ALL SELECT 'AP006-1', 'BA_20' AS "아이템", '1' AS "아이템타입", '2' AS "작업주", 'BA' AS "아이템그룹", 21 "용량", TO_DATE('20190402','YYYYMMDD'), 'A' AS "작업구역" FROM DUAL
    UNION ALL SELECT 'AP007-1', 'BA_22' AS "아이템", '1' AS "아이템타입", '2' AS "작업주", 'BA' AS "아이템그룹", 41 "용량", TO_DATE('20190402','YYYYMMDD'), 'A' AS "작업구역" FROM DUAL
    UNION ALL SELECT 'AP007-2', 'AT_22' AS "아이템", '2' AS "아이템타입", '2' AS "작업주", 'AT' AS "아이템그룹", 13 "용량", TO_DATE('20190404','YYYYMMDD'), 'A' AS "작업구역" FROM DUAL
    UNION ALL SELECT 'AP007-3', 'AT_24' AS "아이템", '3' AS "아이템타입", '3' AS "작업주", 'AT' AS "아이템그룹", 1 "용량", TO_DATE('20190404','YYYYMMDD'), 'A' AS "작업구역" FROM DUAL
    UNION ALL SELECT 'AP007-4', 'AT_25' AS "아이템", '4' AS "아이템타입", '3' AS "작업주", 'AT' AS "아이템그룹", 2 "용량", TO_DATE('20190404','YYYYMMDD'), 'A' AS "작업구역" FROM DUAL
    UNION ALL SELECT 'AP001-1', 'AT_25' AS "아이템", '1' AS "아이템타입", '3' AS "작업주", 'AT' AS "아이템그룹", 3 "용량", TO_DATE('20190404','YYYYMMDD'), 'A' AS "작업구역" FROM DUAL
    UNION ALL SELECT 'AP001-2', 'AT_26' AS "아이템", '2' AS "아이템타입", '3' AS "작업주", 'AT' AS "아이템그룹", 4 "용량", TO_DATE('20190404','YYYYMMDD'), 'A' AS "작업구역" FROM DUAL
    UNION ALL SELECT 'AP002-1', 'AT_26' AS "아이템", '1' AS "아이템타입", '4' AS "작업주", 'AT' AS "아이템그룹", 7 "용량", TO_DATE('20190405','YYYYMMDD'), 'A' AS "작업구역" FROM DUAL
    UNION ALL SELECT 'AP003-1', 'BA_27' AS "아이템", '1' AS "아이템타입", '4' AS "작업주", 'BA' AS "아이템그룹", 22 "용량", TO_DATE('20190405','YYYYMMDD'), 'A' AS "작업구역" FROM DUAL
    UNION ALL SELECT 'AP004-1', 'AT_27' AS "아이템", '1' AS "아이템타입", '5' AS "작업주", 'AT' AS "아이템그룹", 26 "용량", TO_DATE('20190406','YYYYMMDD'), 'A' AS "작업구역" FROM DUAL
    UNION ALL SELECT 'AP005-0', 'AT_28' AS "아이템", '0' AS "아이템타입", '5' AS "작업주", 'AT' AS "아이템그룹", 1 "용량", TO_DATE('20190407','YYYYMMDD'), 'A' AS "작업구역" FROM DUAL
    )
,	W_TIME AS
    (
    SELECT 'AT_20' FROM_ITEM,	'AT_20' TO_ITEM, 0 AS S_TIME  FROM DUAL
    UNION ALL SELECT 'AT_20' FROM_ITEM,	'AT_21' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_20' FROM_ITEM,	'AT_22' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_20' FROM_ITEM,	'AT_23' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_20' FROM_ITEM,	'AT_24' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_20' FROM_ITEM,	'AT_25' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_20' FROM_ITEM,	'AT_26' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_20' FROM_ITEM,	'AT_27' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_20' FROM_ITEM,	'AT_28' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_20' FROM_ITEM,	'BA_20' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_20' FROM_ITEM,	'BA_22' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_20' FROM_ITEM,	'BA_25' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_20' FROM_ITEM,	'BA_26' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_20' FROM_ITEM,	'BA_27' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_21' FROM_ITEM,	'AT_20' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_21' FROM_ITEM,	'AT_21' TO_ITEM, 0    FROM DUAL
    UNION ALL SELECT 'AT_21' FROM_ITEM,	'AT_22' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_21' FROM_ITEM,	'AT_23' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_21' FROM_ITEM,	'AT_24' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_21' FROM_ITEM,	'AT_25' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_21' FROM_ITEM,	'AT_26' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_21' FROM_ITEM,	'AT_27' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_21' FROM_ITEM,	'AT_28' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_21' FROM_ITEM,	'BA_20' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_21' FROM_ITEM,	'BA_22' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_21' FROM_ITEM,	'BA_25' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_21' FROM_ITEM,	'BA_26' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_21' FROM_ITEM,	'BA_27' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_22' FROM_ITEM,	'AT_20' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_22' FROM_ITEM,	'AT_21' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_22' FROM_ITEM,	'AT_22' TO_ITEM, 0    FROM DUAL
    UNION ALL SELECT 'AT_22' FROM_ITEM,	'AT_23' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_22' FROM_ITEM,	'AT_24' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_22' FROM_ITEM,	'AT_25' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_22' FROM_ITEM,	'AT_26' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_22' FROM_ITEM,	'AT_27' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_22' FROM_ITEM,	'AT_28' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_22' FROM_ITEM,	'BA_20' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_22' FROM_ITEM,	'BA_22' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_22' FROM_ITEM,	'BA_25' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_22' FROM_ITEM,	'BA_26' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_22' FROM_ITEM,	'BA_27' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_23' FROM_ITEM,	'AT_20' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_23' FROM_ITEM,	'AT_21' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_23' FROM_ITEM,	'AT_22' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_23' FROM_ITEM,	'AT_23' TO_ITEM, 0    FROM DUAL
    UNION ALL SELECT 'AT_23' FROM_ITEM,	'AT_24' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_23' FROM_ITEM,	'AT_25' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_23' FROM_ITEM,	'AT_26' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_23' FROM_ITEM,	'AT_27' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_23' FROM_ITEM,	'AT_28' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_23' FROM_ITEM,	'BA_20' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_23' FROM_ITEM,	'BA_22' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_23' FROM_ITEM,	'BA_25' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_23' FROM_ITEM,	'BA_26' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_23' FROM_ITEM,	'BA_27' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_24' FROM_ITEM,	'AT_20' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_24' FROM_ITEM,	'AT_21' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_24' FROM_ITEM,	'AT_22' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_24' FROM_ITEM,	'AT_23' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_24' FROM_ITEM,	'AT_24' TO_ITEM, 0    FROM DUAL
    UNION ALL SELECT 'AT_24' FROM_ITEM,	'AT_25' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_24' FROM_ITEM,	'AT_26' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_24' FROM_ITEM,	'AT_27' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_24' FROM_ITEM,	'AT_28' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_24' FROM_ITEM,	'BA_20' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_24' FROM_ITEM,	'BA_22' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_24' FROM_ITEM,	'BA_25' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_24' FROM_ITEM,	'BA_26' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_24' FROM_ITEM,	'BA_27' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_25' FROM_ITEM,	'AT_20' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_25' FROM_ITEM,	'AT_21' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_25' FROM_ITEM,	'AT_22' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_25' FROM_ITEM,	'AT_23' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_25' FROM_ITEM,	'AT_24' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_25' FROM_ITEM,	'AT_25' TO_ITEM, 0    FROM DUAL
    UNION ALL SELECT 'AT_25' FROM_ITEM,	'AT_26' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_25' FROM_ITEM,	'AT_27' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_25' FROM_ITEM,	'AT_28' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_25' FROM_ITEM,	'BA_20' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_25' FROM_ITEM,	'BA_22' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_25' FROM_ITEM,	'BA_25' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_25' FROM_ITEM,	'BA_26' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_25' FROM_ITEM,	'BA_27' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_26' FROM_ITEM,	'AT_20' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_26' FROM_ITEM,	'AT_21' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_26' FROM_ITEM,	'AT_22' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_26' FROM_ITEM,	'AT_23' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_26' FROM_ITEM,	'AT_24' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_26' FROM_ITEM,	'AT_25' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_26' FROM_ITEM,	'AT_26' TO_ITEM, 0    FROM DUAL
    UNION ALL SELECT 'AT_26' FROM_ITEM,	'AT_27' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_26' FROM_ITEM,	'AT_28' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_26' FROM_ITEM,	'BA_20' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_26' FROM_ITEM,	'BA_22' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_26' FROM_ITEM,	'BA_25' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_26' FROM_ITEM,	'BA_26' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_26' FROM_ITEM,	'BA_27' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_27' FROM_ITEM,	'AT_20' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_27' FROM_ITEM,	'AT_21' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_27' FROM_ITEM,	'AT_22' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_27' FROM_ITEM,	'AT_23' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_27' FROM_ITEM,	'AT_24' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_27' FROM_ITEM,	'AT_25' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_27' FROM_ITEM,	'AT_26' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_27' FROM_ITEM,	'AT_27' TO_ITEM, 0    FROM DUAL
    UNION ALL SELECT 'AT_27' FROM_ITEM,	'AT_28' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_27' FROM_ITEM,	'BA_20' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_27' FROM_ITEM,	'BA_22' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_27' FROM_ITEM,	'BA_25' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_27' FROM_ITEM,	'BA_26' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_27' FROM_ITEM,	'BA_27' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_28' FROM_ITEM,	'AT_20' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_28' FROM_ITEM,	'AT_21' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_28' FROM_ITEM,	'AT_22' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_28' FROM_ITEM,	'AT_23' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_28' FROM_ITEM,	'AT_24' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_28' FROM_ITEM,	'AT_25' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_28' FROM_ITEM,	'AT_26' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_28' FROM_ITEM,	'AT_27' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'AT_28' FROM_ITEM,	'AT_28' TO_ITEM, 0    FROM DUAL
    UNION ALL SELECT 'AT_28' FROM_ITEM,	'BA_20' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_28' FROM_ITEM,	'BA_22' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_28' FROM_ITEM,	'BA_25' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_28' FROM_ITEM,	'BA_26' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'AT_28' FROM_ITEM,	'BA_27' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_20' FROM_ITEM,	'AT_20' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_20' FROM_ITEM,	'AT_21' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_20' FROM_ITEM,	'AT_22' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_20' FROM_ITEM,	'AT_23' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_20' FROM_ITEM,	'AT_24' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_20' FROM_ITEM,	'AT_25' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_20' FROM_ITEM,	'AT_26' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_20' FROM_ITEM,	'AT_27' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_20' FROM_ITEM,	'AT_28' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_20' FROM_ITEM,	'BA_20' TO_ITEM, 0    FROM DUAL
    UNION ALL SELECT 'BA_20' FROM_ITEM,	'BA_22' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_20' FROM_ITEM,	'BA_25' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_20' FROM_ITEM,	'BA_26' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_20' FROM_ITEM,	'BA_27' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_22' FROM_ITEM,	'AT_20' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_22' FROM_ITEM,	'AT_21' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_22' FROM_ITEM,	'AT_22' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_22' FROM_ITEM,	'AT_23' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_22' FROM_ITEM,	'AT_24' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_22' FROM_ITEM,	'AT_25' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_22' FROM_ITEM,	'AT_26' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_22' FROM_ITEM,	'AT_27' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_22' FROM_ITEM,	'AT_28' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_22' FROM_ITEM,	'BA_20' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_22' FROM_ITEM,	'BA_22' TO_ITEM, 0    FROM DUAL
    UNION ALL SELECT 'BA_22' FROM_ITEM,	'BA_25' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_22' FROM_ITEM,	'BA_26' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_22' FROM_ITEM,	'BA_27' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_25' FROM_ITEM,	'AT_20' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_25' FROM_ITEM,	'AT_21' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_25' FROM_ITEM,	'AT_22' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_25' FROM_ITEM,	'AT_23' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_25' FROM_ITEM,	'AT_24' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_25' FROM_ITEM,	'AT_25' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_25' FROM_ITEM,	'AT_26' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_25' FROM_ITEM,	'AT_27' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_25' FROM_ITEM,	'AT_28' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_25' FROM_ITEM,	'BA_20' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_25' FROM_ITEM,	'BA_22' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_25' FROM_ITEM,	'BA_25' TO_ITEM, 0    FROM DUAL
    UNION ALL SELECT 'BA_25' FROM_ITEM,	'BA_26' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_25' FROM_ITEM,	'BA_27' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_26' FROM_ITEM,	'AT_20' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_26' FROM_ITEM,	'AT_21' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_26' FROM_ITEM,	'AT_22' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_26' FROM_ITEM,	'AT_23' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_26' FROM_ITEM,	'AT_24' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_26' FROM_ITEM,	'AT_25' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_26' FROM_ITEM,	'AT_26' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_26' FROM_ITEM,	'AT_27' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_26' FROM_ITEM,	'AT_28' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_26' FROM_ITEM,	'BA_20' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_26' FROM_ITEM,	'BA_22' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_26' FROM_ITEM,	'BA_25' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_26' FROM_ITEM,	'BA_26' TO_ITEM, 0    FROM DUAL
    UNION ALL SELECT 'BA_26' FROM_ITEM,	'BA_27' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_27' FROM_ITEM,	'AT_20' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_27' FROM_ITEM,	'AT_21' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_27' FROM_ITEM,	'AT_22' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_27' FROM_ITEM,	'AT_23' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_27' FROM_ITEM,	'AT_24' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_27' FROM_ITEM,	'AT_25' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_27' FROM_ITEM,	'AT_26' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_27' FROM_ITEM,	'AT_27' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_27' FROM_ITEM,	'AT_28' TO_ITEM, 10   FROM DUAL
    UNION ALL SELECT 'BA_27' FROM_ITEM,	'BA_20' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_27' FROM_ITEM,	'BA_22' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_27' FROM_ITEM,	'BA_25' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_27' FROM_ITEM,	'BA_26' TO_ITEM, 5    FROM DUAL
    UNION ALL SELECT 'BA_27' FROM_ITEM,	'BA_27' TO_ITEM, 0    FROM DUAL
    )

by 마농 [2019.04.17 16:32:25]

기존 질문의 설명을 다 이해했다고 가정하고 아무런 설명 없이 새로운 질문 올리시지 마시고
새로운 질문 올리실 때는 새로운 설명을 해주세요.
여긴 설명이 없어서 기존 질문글에 답글 달았습니다.

by 홍길덩이 [2019.04.18 12:00:06]

네 알겠습니다!

댓글등록

SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code(

) 버튼을 클릭하여 작성 하시면 됩니다.

로그인 사용자만 댓글을 작성 할 수 있습니다. 로그인, 회원가입

데이터베이스 질문과 답변