oracle 行转列

cenhonggang86

于 2010-10-11 17:29:12 发布

阅读量146

点赞数

分类专栏： Oracle 文章标签： Oracle

本文链接：https://blog.youkuaiyun.com/cenhonggang86/article/details/83729675

版权

Oracle 专栏收录该内容

24 篇文章

订阅专栏

select '{' || d.il1_id || '}{' || d.il2_id || '}{' || d.il3_id || '}{' ||
d.il4_id || '}{' || d.il5_id || '}' ids
from t_dept d
where d.idept_id = 1878;

select regexp_replace(regexp_substr((select '{' || d.il1_id || '}{' ||
                                           d.il2_id || '}{' || d.il3_id || '}{' ||
                                           d.il4_id || '}{' || d.il5_id || '}'
                                      from t_dept d
                                     where d.idept_id = 1878),
                                    '{([0-9]*)}',
                                    1,
                                    level),
                      '^{(.*)}$',
                      '\1')
from dual
connect by level <= 5;