RULE hint is available in 10g ... Raj ------------------------------------------------------------------------ --------=20 Rajendra dot Jamadagni at nospamespn dot com=20 All Views expressed in this email are strictly personal.=20 select standard_disclaimer from company_requirements;=20 QOTD: Any clod can have facts, having an opinion is an art ! -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Duret, Kathy Sent: Wednesday, May 05, 2004 12:45 PM To: 'oracle-l@xxxxxxxxxxxxx' Subject: RE: Wrong results using decode when db upgraded to 9205 A question about using the Rule hint for new code? Forgive me, but isn't the rule going away in 10G and I would assume the rule hint would no longer work or rather be ignored in 10G so why put rule into new code to have to rewrite it when you migrate to 10G. Haven't tested it in 10G so I don't know for sure. Has anyone? Kathy ---------------------------------------------------------------- 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 //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------