select a.COLUMN_NAME,a.DATA_TYPE,b.COMMENTS from user_col_comments b left join user_tab_columns a on  a.Table_Name=b.Table_Name and  a.column_name=b.column_name where a.Table_Name='表名' and b.Table_Name='表名'