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