select ‘select ‘||to_char(wm_concat(column_name||‘ as ‘||column_name))||‘from $$schema_stage.‘||table_name from user_tab_columns group by table_name
采集原表时用来生成采集语句
select ‘select ‘||to_char(wm_concat(column_name||‘ as ‘||column_name))||‘from $$schema_stage.‘||table_name from user_tab_columns group by table_name
采集原表时用来生成采集语句
原文：https://www.cnblogs.com/Babylon/p/8427671.html