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

采集原表时用来生成采集语句

posted @ 2018-02-07 17:27  巴啦啦大魔王  阅读(161)  评论(0编辑  收藏  举报