Oracle 导出表结构信息

select u.table_name 表名,u.column_name 字段名,a.DATA_TYPE 字段类型,a.DATA_LENGTH 字段长度,u.comments 注释 from user_col_comments u,all_tab_columns a

where u.table_name=a.TABLE_NAME and a.OWNER='XMUEDU' and u.column_name=a.COLUMN_NAME --and a.TABLE_NAME= 'BASIC_CODE'

order by u.table_name