查询数据库表 名和评论
select table_name,comments from user_tab_comments where comments is not null
String sql="select ct.cname clname,ct.ccommonts comname,tt.ttype typename from "+
"(select c.TABLE_NAME tname,c.COLUMN_NAME cname ,c.COMMENTS ccommonts From user_col_comments c where c.COMMENTS is not null and c.TABLE_NAME='"+tableName+"') ct,"+
"(select t.column_name cname,t.DATA_TYPE ttype from user_tab_columns t where t.TABLE_NAME='"+tableName+"' and t.data_type <>'"+"CLOB"+"' and t.DATA_TYPE <> '"+"BLOB"+"') tt "+
" where ct.cname=tt.cname";