–查询数据库表结构
select table_name 表名, a.COLUMN_NAME 字段名,
(select b.comments from user_col_comments b where b.table_name = a.table_name and b.column_name = a.column_name) 字段备注,
decode(a.data_type, 'VARCHAR2', 'VARCHAR', a.data_type)||'('||a.data_length||')' 字段类型,
decode(a.nullable, 'N', 'Y', 'N') 字段是否必填
from user_tab_columns a
where table_name = 'T_tablename';