直接写select * 一直被告知效率低 根据表名生成 所有字段的语句如下 主要是使用了WM_CONCAT这个函数
select 'select ' || a.cols || ' from ' || a.table_name
from (select t.table_name, WM_CONCAT(t.COLUMN_NAME) cols
from user_tab_columns t
where t.TABLE_NAME = ''
group by t.table_name) a;
from (select t.table_name, WM_CONCAT(t.COLUMN_NAME) cols
from user_tab_columns t
where t.TABLE_NAME = ''
group by t.table_name) a;