안녕하세요.

==================================================

col1         col2
1                 1
1                 2
1                 3
1                 4
1                 5
1                 6
1                 7
1                 8
1                 9
1                 10
1                 11
1                 12
1                 13
1                 14
1                 15
        .

        .

        .

1                 100

2                 1
2                 2
2                 3
2                 4
2                 5
2                 6
2                 7
2                 8
2                 9
2                 10
        .

        .

        .

2                90
 
 

==================================================

쉬운방법이 있을까.. 해서 이렇게 글을 올려 봅니다

row단위로 나와있는 데이터를  한줄로 표현할려고 합니다.

select '1', '2', '3', '4', '5', '6', '7', '8', '9', '10'...............................................100

from dual

where col1 =  '1' ;

일일이 select 절에 쓰기 힘들어서..  쉽게  한줄로 표현 하는 방법 좀 알려주세요 ㅠ