列及注释

---生成insert语句
select ','||b.column_name ins1,'--'||b.comments ins2,',a.'||b.column_name||' as '||b.column_name sel from user_tab_cols a,user_col_comments b
where a.column_name=b.column_name and a.table_name='TW_FI_HOUSEHOLD_QUE_TAG_D' and b.table_name='TW_FI_HOUSEHOLD_QUE_TAG_D'
order by a.column_id ;
---验证多少个列
select column_id,column_name from user_tab_cols where table_name='TW_FI_HOUSEHOLD_QUE_TAG_D';

转载于:https://www.cnblogs.com/jiangqingfeng/p/11130807.html