RE: Wrong results using decode when db upgraded to 9205

  • From: "Jamadagni, Rajendra" <Rajendra.Jamadagni@xxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 5 May 2004 12:54:05 -0400

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
-----------------------------------------------------------------

Other related posts: