vitaair的博客

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

-- 查询指定表里字段及字段注释 select column_name,data_type,data_length,DATA_PRECISION ,DATA_SCALE from all_tab_columns where table_name = UPPER('test11'); -- 查询字段及字段注释 select COLUMN_NAME,COMMENTS from user_col_comments where TABLE_NAME = UPPER('test11'); -- 查询所有表及表注.