SELECT '1' || '-' || TO_CHAR(T1.WIDTH_NO) || '-' || TO_CHAR(T2.HEIGHT_NO) AS CELL_DIS
FROM (SELECT LEVEL WIDTH_NO
FROM DUAL
CONNECT BY LEVEL <= 14) T1,
(SELECT LEVEL HEIGHT_NO
FROM DUAL
CONNECT BY LEVEL <= 21) T2
필드
1-1-1
1-2-1
1-3-1
1-4-1
.
.
.
1-2-1
이걸..
1-1-1 / 1-2-1 / 1-3-1 / ...... 1-14-1
1-1-2 / 1-2-2 / 1-3-2 /........1-14-2
.
.
.
1-1-21/ 1-2-21 / 1-3-21/.......1-14/21
이렇게 표현하고 싶습니다....
고수님들 부탁드려요~~
|