查询表字段名 select column_name,data_type,data_length,DATA_PRECISION ,DATA_SCALE from all_tab_columns where table_name='你的表名'
支持,你先查询出表的所有字段,然后存储数据吧!1, select column_name,data_type,data_length,DATA_PRECISION ,DATA_SCALE from all_tab_columns where table_name=tbname2,insert into tbname ......
select column_name,data_type,data_length,DATA_PRECISION ,DATA_SCALE
from all_tab_columns where table_name='你的表名'
select column_name,data_type,data_length,DATA_PRECISION ,DATA_SCALE
from all_tab_columns where table_name=tbname2,insert into tbname ......