orcale 行转列与列转行 查询临时表名

一、行转列

  select id, vnum, to_char(wmsys.wm_concat(vname)) c 
from tab_test group by id,vnum;

  行转列排序

  

 select oeb01, to_char(wm_concat(tc_ogb11) over (partition by tc_ogb11 order by ta_agd01)) r from oeb_file,tc_ogb_file,agd_file
where oeb01=tc_ogb02 AND  OEB03=tc_ogb03 and agd01='002' and agd02=ta_oeb17 

二、列转行

create table ta as (select '/ABC/AA/AD/ABD/JI/CC/ALSKD/ALDKDJ' id from sma_file)

select regexp_substr(id,'[^/]+',1,rownum) id from ta

connect by rownum <= length(regexp_replace(id,'[^/]+'))

三、orcale查询临时表名：

       在sys库中执行语句：   

       select * from dba_objects where object_name LIKE '%P999_TMP%'

        P999_TMP：代码中命名的临时表名