oracle表结构查询

select t.table_name 表名,

t.column_name as 字段名,

t.data_type as 字段类型,

t.data_length as 字段长度,

t.nullable as 是否为空,

t.data_default as 默认值

from USER_TAB_COLS t where TABLE_NAME ='table_name';