Re: Where clause apparently failing
- From: Daniel Fink <daniel.fink@xxxxxxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 Sep 2008 11:35:04 -0600
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@xxxxxxxxxxx
(530) 754-6208
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
