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: Oracle 10g - Putting a where clause on a column with a check constraint.

Re: Oracle 10g - Putting a where clause on a column with a check constraint.

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 22 Mar 2006 14:00:47 -0800
Message-ID: <1143064846.162357@yasure.drizzle.com> 





Jon wrote:


> More Information...

> 

> If I make the constraint NOVALIDATA or if I disable the constraint, the

> queries work as expected. This is a huge stumbling block to our

> integration with 10g.




Why? How? What is the subject of this thread?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)


Received on Wed Mar 22 2006 - 16:00:47 CST












Original text of this message













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