select
regexp_substr(a1, '[^,]+', 1, level) as a1
from (
select
a1 || ',' || b1 || ',' || c1 as a1
from (
select
'aa1' as a1
, 'aa2' as b1
, 'aa3' as c1
from dual
)
)
connect by regexp_substr(a1, '[^,]+', 1, level) is not null
'DataBase > Sql' 카테고리의 다른 글
| [Sql] Trunc (0) | 2012.11.22 |
|---|---|
| [Oracle] update where (0) | 2012.11.12 |
| [Sql] NoSql (0) | 2012.01.04 |
| [Sql] Select시 데이터 가로로 출력! (0) | 2011.11.04 |
| [Sql] Analytic Function (0) | 2011.10.20 |