Re: Where clause apparently failing
Date: Fri, 19 Sep 2008 12:54:07 -0400
Message-ID: <OFAB3CA117.E0BCA7E0-ON852574C9.005CBC5A-852574C9.005CA318@lnotes-gw.ent.nwie.net>
this is a SWAG,
did someone change the normal way the % sign works and map it to # instead? I know it don't make sense but thought i'd throw it out anyways on a fridat afternoon :)
joe
Phineas says, "Where's Perry?"
William Wagman <wjwagman_at_ucdavis.edu>
Sent by: oracle-l-bounce_at_freelists.org
09/19/2008 12:30 PM
Please respond to wjwagman_at_ucdavis.edu
From
William Wagman <wjwagman_at_ucdavis.edu>
To
"oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
cc
Subject
Where clause apparently failing
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
Received on Fri Sep 19 2008 - 11:54:07 CDT