PL/SQL question: Displaying two columns for duplicate records

Toad for Oracle & DevOps Toolkit
2

I worked up something similar using DBA_TABLES. Move your group query up into a “with” clause, and then you can join that back to your table.

with dups as 
  (select table_name, count(*)
   from dba_tables
   group by table_name
   having count(*) > 1)
select d.*, t.* 
from   dba_tables t, dups d
where  t.table_name = d.table_name