select
b.column_name column_name --字段名
,b.data_type data_type --字段类型
,b.data_length --字段长度
,a.comments comments --字段注释
from all_tab_columns B
LEFT JOIN user_col_comments A ON a.table_name = b.table_name AND A.COLUMN_NAME=B.COLUMN_NAME
where a.Table_Name like '%表名%'