Re: Where clause apparently failing

What is the execution plan? It is not unheard of to have certain operations fail to produce proper results.

What happens if you query just the base tables involved?

-- 
Daniel Fink

OptimalDBA.com - Oracle Performance, Diagnosis, Data Recovery and Training

OptimalDBA    http://www.optimaldba.com
Oracle Blog   http://optimaldba.blogspot.com

Lost Data?    http://www.ora600.be/


William Wagman wrote:


> Greetings,

>

> I'm running 64-bit Oracle 10.2.0.4.0 EE on Windows server 2003.

>

> The select statement

>

> select patient_id, study_number

> from ucdv_cc_summaryae

> where study_number = 'UCDCC#128';

>

> returns 8693 rows. Many of these rows have study_number other than ucdcc#128 including ucdcc#157, ucdcc#159, ucdcc#165, ucdcc#171, etc.

>

> ucdv_cc_summaryae is a view and the column study_number is varchar2(100). I am perplexed and would appreciate any thoughts. I am still having difficulty getting to Oracle docs online.

>

> Thanks.

>

> Bill Wagman

> Univ. of California at Davis

> IET Campus Data Center

> wjwagman_at_ucdavis.edu

> (530) 754-6208

> --

> http://www.freelists.org/webpage/oracle-l

>

>

>   



--
http://www.freelists.org/webpage/oracle-l