I upgraded a dev db from 9202 to 9205 and one query with a DECODE
statement is giving wrong results. The whole query is big, but decode
statement looks like ...
"and decode('C8','C8',237,0) = 237" If the same statement is re-written
using case it works fine. I am searching on metablink but wanted to
check here first. This same query with same decode statement works fine
on 9202 database.
Any hearsay? Known issues? Experiences?
Thanks
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
select standard_disclaimer from company_requirements;
QOTD: Any clod can have facts, having an opinion is an art !
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
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
Received on Wed May 05 2004 - 10:23:40 CDT
