select * from dba_ind_columns where table_owner = 'PIONEER' and table_name in (select table_name from (select table_name,count(*)
from dba_ind_columns
where table_owner = 'PIONEER' and column_name in (select a.column_name from (select column_name, count(*)
from dba_ind_columns
where table_owner = 'PIONEER' having count(*) >= '2'
group by column_name) a) group by table_name having count(*) >= '2'))
阅读(2569) | 评论(0) | 转发(0) |