vitaair的博客

select 字段名,count(*) from table group by 字段名 having count(*) > 1select name1,name2,count(*) from table group by name1,name2 having count(*) > 1

-- 查询指定表里字段及字段注释select column_name,data_type,data_length,DATA_PRECISION ,DATA_SCALEfrom all_tab_columnswhere table_name = UPPER('test11');-- 查询字段及字段注释select COLUMN_NAME,COMMENTSfrom user_col_commentswhere TABLE_NAME = UPPER('test11');-- 查询所有表及表注.