piliskys

select  
' create  materialized view  ' || max (a.table_name) || chr( 10 ) ||
    ' tablespace staging refresh fast  as select ' || chr( 10 ) ||
 substr( max (sys_connect_by_path(a.column_name || chr( 10 ), ' , ' )), 2 ) ||
  ' from  ' || max (a.table_name) || ' @zhengguan t; ' -- 这里是DBLINK
 
   from  
(  select  row_number()  over ( PARTITION  BY  g.table_name   order   by  g.column_id  )  rn 
    ,g.table_name,g.column_name   from  
         user_tab_cols  g
           where  g.table_name  = ' TB_LVY_INCREASEDECREASEDATA '   -- 这里是要建的表名
          ) a
          
           start  with  rn = 1
          connect  by   rn  =   prior rn  + 1