Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query to select "check" constraints?
On 17 Aug 2001, stanb_at_panix.com wrote:
> Thanks, I added that, but I'm still geting a lareg number of
> rows.
Do you get more than one row when you execute
select count(*)
from USER_CONSTRAINTS
where TABLE_NAME = 'BRKR'
and CONSTRAINT_TYPE = 'C'
Also, you said 543 rows are returned.
How many rows are in table BRKR?
-- Galen Boyer It seems to me, I remember every single thing I know.Received on Fri Aug 17 2001 - 18:33:06 CDT