A1 1 L5 PLC0001 김가나
A1 2 L4 PLC0002 김다라
A1 3 L4 PLC0003 김다라
A1 4 L4 PLC0004 김가나
A1 5 L3 PLC0001 김마바
A2 1 L4 PLC0004 김다라
A2 2 L4 PLC0005 김다라
A2 3 L4 PLC0006 김마바
A2 4 L2 PLC0001 김마바
A3 1 L4 PLC0045 김마바
A3 2 L4 PLC0048 김마바
A3 3 L3 PLC0449 김가나
A3 4 L3 PLC0004 김다라
A3 5 L3 PLC0005 김다라
A3 6 L3 PLC0006 김다라
A3 7 L2 PLC0007 김가나
A3 8 L2 PLC0008 김가나
이렇게 나온 data를--------------------------------
L5 |
A1 1 L5 PLC0001 김가나 |
|
|
L4 |
A1 2 L4 PLC0002 김다라 |
A2 1 L4 PLC0004 김다라 |
A3 1 L4 PLC0045 김마바 |
L4 |
A1 3 L4 PLC0003 김다라 |
A2 2 L4 PLC0005 김다라 |
A3 2 L4 PLC0048 김마바 |
L4 |
A1 4 L4 PLC0004 김가나 |
A2 3 L4 PLC0006 김마바 |
|
L3 |
A1 5 L3 PLC0001 김마바 |
|
A3 3 L3 PLC0449 김가나 |
L3 |
|
|
A3 4 L3 PLC0004 김다라 |
L3 |
|
|
A3 5 L3 PLC0005 김다라 |
L3 |
|
|
A3 6 L3 PLC0006 김다라 |
L2 |
|
A2 4 L2 PLC0001 김마바 |
A3 7 L2 PLC0007 김가나 |
L2 |
|
|
A3 8 L2 PLC0008 김가나 |
이렇게 바꾸고 싶습니다.
SELECT 'A1' AS TBNAME, 1 AS SEQ, 'L5' AS GRADE, 'PLC0001' AS ITEMCD, '김가나' AS EMPNM FROM DUAL
UNION ALL
SELECT 'A1' AS TBNAME, 2 AS SEQ, 'L4' AS GRADE, 'PLC0002' AS ITEMCD, '김다라' AS EMPNM FROM DUAL
UNION ALL
SELECT 'A1' AS TBNAME, 3 AS SEQ, 'L4' AS GRADE, 'PLC0003' AS ITEMCD, '김다라' AS EMPNM FROM DUAL
UNION ALL
SELECT 'A1' AS TBNAME, 4 AS SEQ, 'L4' AS GRADE, 'PLC0004' AS ITEMCD, '김가나' AS EMPNM FROM DUAL
UNION ALL
SELECT 'A1' AS TBNAME, 5 AS SEQ, 'L3' AS GRADE, 'PLC0001' AS ITEMCD, '김마바' AS EMPNM FROM DUAL
UNION ALL
SELECT 'A2' AS TBNAME, 1 AS SEQ, 'L4' AS GRADE, 'PLC0004' AS ITEMCD, '김다라' AS EMPNM FROM DUAL
UNION ALL
SELECT 'A2' AS TBNAME, 2 AS SEQ, 'L4' AS GRADE, 'PLC0005' AS ITEMCD, '김다라' AS EMPNM FROM DUAL
UNION ALL
SELECT 'A2' AS TBNAME, 3 AS SEQ, 'L4' AS GRADE, 'PLC0006' AS ITEMCD, '김마라' AS EMPNM FROM DUAL
UNION ALL
SELECT 'A2' AS TBNAME, 4 AS SEQ, 'L2' AS GRADE, 'PLC0001' AS ITEMCD, '김마라' AS EMPNM FROM DUAL
UNION ALL
SELECT 'A3' AS TBNAME, 1 AS SEQ, 'L4' AS GRADE, 'PLC0045' AS ITEMCD, '김마바' AS EMPNM FROM DUAL
UNION ALL
SELECT 'A3' AS TBNAME, 2 AS SEQ, 'L4' AS GRADE, 'PLC0048' AS ITEMCD, '김마바' AS EMPNM FROM DUAL
UNION ALL
SELECT 'A3' AS TBNAME, 3 AS SEQ, 'L3' AS GRADE, 'PLC0049' AS ITEMCD, '김가나' AS EMPNM FROM DUAL
UNION ALL
SELECT 'A3' AS TBNAME, 4 AS SEQ, 'L3' AS GRADE, 'PLC0004' AS ITEMCD, '김다라' AS EMPNM FROM DUAL
UNION ALL
SELECT 'A3' AS TBNAME, 5 AS SEQ, 'L3' AS GRADE, 'PLC0005' AS ITEMCD, '김다라' AS EMPNM FROM DUAL
UNION ALL
SELECT 'A3' AS TBNAME, 6 AS SEQ, 'L3' AS GRADE, 'PLC0006' AS ITEMCD, '김다라' AS EMPNM FROM DUAL
UNION ALL
SELECT 'A3' AS TBNAME, 7 AS SEQ, 'L3' AS GRADE, 'PLC0007' AS ITEMCD, '김가나' AS EMPNM FROM DUAL
UNION ALL
SELECT 'A3' AS TBNAME, 8 AS SEQ, 'L2' AS GRADE, 'PLC0008' AS ITEMCD, '김가나' AS EMPNM FROM DUAL
|