Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Query to select "check" constraints?

Re: Query to select "check" constraints?

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 17 Aug 2001 16:53:15 -0500
Message-ID: <u7kw2i3zr.fsf@verizon.net>


On 17 Aug 2001, galenboyer_at_hotpop.com wrote:

> On 17 Aug 2001, stanb_at_panix.com wrote:
>

>> But still returns 543 rows for this one table! And takes _a
>> long_ time to run.

>
> There is an owner column, which would mean if there are more
> than one schema that owns a table named BRKR, then you will get
> a cartesian product.

Arrrgh! This isn't the issue. The user_* tables should only show you your tables.

-- 
Galen Boyer
It seems to me, I remember every single thing I know.
Received on Fri Aug 17 2001 - 16:53:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US