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
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 userReceived on Thu Aug 01 1996 - 00:00:00 CEST