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';
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';