From oracle-l-bounce@freelists.org Wed May 5 11:55:06 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i45Gspe17718 for ; Wed, 5 May 2004 11:55:01 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i45Gsf617679 for ; Wed, 5 May 2004 11:54:51 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5CF6872DA2C; Wed, 5 May 2004 11:42:48 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29115-23; Wed, 5 May 2004 11:42:48 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6BB2772D818; Wed, 5 May 2004 11:42:47 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 05 May 2004 11:41:33 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 394A872D8E6 for ; Wed, 5 May 2004 11:40:18 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28001-98 for ; Wed, 5 May 2004 11:40:18 -0500 (EST) Received: from venus.espn.com (venus.espn.com [204.149.192.12]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AE10672D8D6 for ; Wed, 5 May 2004 11:40:17 -0500 (EST) content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 Subject: RE: Wrong results using decode when db upgraded to 9205 Date: Wed, 5 May 2004 12:54:05 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Wrong results using decode when db upgraded to 9205 Thread-Index: AcQywMcuNoGjpzdPTry0H8cIJM/0/wAALtlg From: "Jamadagni, Rajendra" To: X-OriginalArrivalTime: 05 May 2004 16:54:06.0166 (UTC) FILETIME=[93B8DF60:01C432C1] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4466 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Rajendra.Jamadagni@espn.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Duret, Kathy Sent: Wednesday, May 05, 2004 12:45 PM To: 'oracle-l@freelists.org' 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@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 -----------------------------------------------------------------