SELECT
tab.COMMENTS 表中文名称,
utc.Table_Name 表名称,
utc.column_name as 字段名,
utc.data_type as 字段类型,
utc.data_length as 数据长度,
utc.data_precision as 数据精度,
utc.nullable as 是否为空,
ucc.comments as 备注
from user_tab_columns utc,user_col_comments ucc,SYS.USER_TAB_COMMENTS tab
where utc.column_name = ucc.column_name and utc.Table_Name = ucc.Table_Name and utc.Table_Name = tab.TABLE_NAME
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。