Re: Confused about "check" style constraunts

In <6swg7.24222$wX5.1749360_at_news20.bellglobal.com> "Stephen Bell" <stephen.bell_at_cgi.ca> writes:

>Hi Stan,

>I'd bet even Jonathan's salary (kidding Jonathan :) that you've got a
>cartesian product; at least you imply that because you state one of the
>tables has only 62 rows...depending on what you need, try starting with
>something like:

>SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS
>WHERE CONSTRAINT_TYPE = 'C' ;
You mean, like this, right?

select
count(CONSTRAINT_NAME)
from
USER_CONSTRAINTS C
where CONSTRAINT_TYPE = 'C'
AND TABLE_NAME = 'BRKR' COUNT(CONSTRAINT_NAME)

                   549

AND TABLE_NAME = 'BRKR'
/

I'm still puzzled. Received on Tue Aug 21 2001 - 13:03:31 CDT