select t2.comments as 字段中文名,t1.column_name as 字段名, t1.data_type||'('||t1.DATA_LENGTH||')' as 字段类型,'是' as 必填项, t2.comments as 取值范围及描述
from user_tab_columns t1
left join user_col_comments t2
on t1.TABLE_NAME=t2.table_name and t1.COLUMN_NAME=t2.column_name
where t1.table_name = 'T_ORG_INFORMATION';
from user_tab_columns t1
left join user_col_comments t2
on t1.TABLE_NAME=t2.table_name and t1.COLUMN_NAME=t2.column_name
where t1.table_name = 'T_ORG_INFORMATION';