查询某张表的表名，字段名，数据类型，长度，是否为空，列ID
select t.table_name, t.column_name, t.data_type, t.data_length, t.nullable, t.column_id
from user_tab_columns t
where t.table_name = 'tableName'
order by t.column_id;
