> -----Original Message-----
> "and decode('C8','C8',237,0) = 237"
I have some interest in this since 9.2.0.5 might appear around here, and
there are plenty of decode statements running around this place. But I have
to say that I get the feeling something in the diagnostic process is not
right: The decode clause listed here will ALWAYS return 237; that is, this
is do-nothing decode clause.
Was this: decode(field_name, 'C8' ...
or: decode(parameter_name, 'C8' ...
??
If it's a field_name, then I wonder you get with:
select count(*) from table where field_name = 'C8';
Followed up with:
select count(*) from table where decode(field_name,'C8',237,0) = 237;
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------