万能的sql 查询字段语句

SELECT t.table_name table_name,--表英文名称

   t.comments table_comments,--表中文名称

   t1.column_name column_name,--列名英文

   t2.DATA_TYPE || '(' || t2.DATA_LENGTH || ')' date_type, --字段类型及长度

   t1.COMMENTS column_comments  --列名中文

FROM user_tab_comments t,

     User_Col_Comments t1,

     User_Tab_Cols t2

WHERE 1 = 1

AND t.table_name = t1.table_name

AND t2.column_name = t1.column_name

AND t2.table_name = t1.table_name

AND t1.comments LIKE '%%';