Re: SQL CORR SUBQUERY EXPERTS

From: Simon Griffiths <griffithss_at_entc1.agw.bt.co.uk>
Date: 1996/08/01
Message-ID: <4tqm3s$cce_at_pheidippides.axion.bt.co.uk>#1/1


Try

---
select table_name,count(*) from user_constraints x 
group by table_name                                
having count(*) > 1                                

I've used user_contraints as you would have to take into 
account the table owner if dba_constraints were user
Received on Thu Aug 01 1996 - 00:00:00 CEST

Original text of this message