ETL采集原表语句生成

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