|
이러데이타를
ABC-1001 A1 11 111 1
ABC-1002 A1 22 222 2
ABC-1003 A1 33 333 3
ABC-1004 A1 44 444 4
ABC-1005 A1 55 555 5
ABC-1006 A1 66 666 6
ABC-1007 A1 77 777 7
ABC-1008 A1 88 888 8
ABC-1009 A1 99 999 9
ABC-1010 A1 100 1000 10 유니온을쓰지않고 아래처럼 만들수있나요????? **** 부탁드립니다. __;; 암만해도 안되서요
| A1 |
ABC-1001 |
ABC-1002 |
ABC-1003 |
ABC-1004 |
| A1 |
11 |
22 |
33 |
44 |
| A1 |
111 |
222 |
333 |
444 |
| A1 |
ABC-1005 |
ABC-1006 |
ABC-1007 |
ABC-1008 |
| A1 |
55 |
66 |
77 |
88 |
| A1 |
555 |
666 |
777 |
888 |
| A1 |
ABC-1009 |
ABC-1010 |
|
|
| A1 |
99 |
100 |
|
|
| A1 |
999 |
1000 |
|
|
SELECT 'ABC-1001' eqpname, 'A1' eqpgu, 11 v1, 111 v2, 1 seq FROM DUAL UNION ALL SELECT 'ABC-1002' eqpname, 'A1' eqpgu, 22 v1, 222 v2, 2 seq FROM DUAL UNION ALL SELECT 'ABC-1003' eqpname, 'A1' eqpgu, 33 v1, 333 v2, 3 seq FROM DUAL UNION ALL SELECT 'ABC-1004' eqpname, 'A1' eqpgu, 44 v1, 444 v2, 4 seq FROM DUAL UNION ALL SELECT 'ABC-1005' eqpname, 'A1' eqpgu, 55 v1, 555 v2, 5 seq FROM DUAL UNION ALL SELECT 'ABC-1006' eqpname, 'A1' eqpgu, 66 v1, 666 v2, 6 seq FROM DUAL UNION ALL SELECT 'ABC-1007' eqpname, 'A1' eqpgu, 77 v1, 777 v2, 7 seq FROM DUAL UNION ALL SELECT 'ABC-1008' eqpname, 'A1' eqpgu, 88 v1, 888 v2, 8 seq FROM DUAL UNION ALL SELECT 'ABC-1009' eqpname, 'A1' eqpgu, 99 v1, 999 v2, 9 seq FROM DUAL UNION ALL SELECT 'ABC-1010' eqpname, 'A1' eqpgu, 100 v1, 1000 v2, 10 seq FROM DUAL |
