Re: Simple Query Help....

From: Glenn Feiner <gfeiner_at_gmail.com>
Date: 10 Oct 2006 13:18:31 -0700
Message-ID: <1160511511.016027.254530@h48g2000cwc.googlegroups.com>

Analytics!!!!

select *
  from dba_synonyms
 where synonym_name in (select synonym_name

                          from (select synonym_name,
                                       row_number() over(partition by
synonym_name order by synonym_name, owner) RN
                                  from dba_synonyms t)
                         where rn = 2)

 order by synonym_name, owner

amerar_at_iwc.net wrote:
> Hey All,
>
> I just need a bit of help with this query. I want to select all of the
> duplicate synonym names in the database. However, I want to list not
> just the synonym name, but also the owner of the synonym
> name............
>
> Thanks.
Received on Tue Oct 10 2006 - 15:18:31 CDT