From oracle-l-bounce@freelists.org Fri Jul 16 19:58:31 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6H0wGf05742 for ; Fri, 16 Jul 2004 19:58:26 -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 i6H0w6605731 for ; Fri, 16 Jul 2004 19:58:16 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B87CA72C38C; Fri, 16 Jul 2004 19:38:05 -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 21056-89; Fri, 16 Jul 2004 19:38:05 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1DFDC72C3C0; Fri, 16 Jul 2004 19:38:05 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 16 Jul 2004 19:36:43 -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 BB45B72C221 for ; Fri, 16 Jul 2004 19:36:42 -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 20728-95 for ; Fri, 16 Jul 2004 19:36:42 -0500 (EST) Received: from relay.pair.com (relay.pair.com [209.68.1.20]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 67F2172C1A3 for ; Fri, 16 Jul 2004 19:36:42 -0500 (EST) Received: (qmail 73547 invoked from network); 17 Jul 2004 01:01:59 -0000 Received: from gennick.hiawatha.jamadots.com (HELO ThinkpadX30.gennick.com) (12.37.13.198) by relay.pair.com with SMTP; 17 Jul 2004 01:01:59 -0000 X-pair-Authenticated: 12.37.13.198 Date: Fri, 16 Jul 2004 21:01:58 -0400 From: Jonathan Gennick X-Mailer: The Bat! (v1.62 Christmas Edition) Personal X-Priority: 3 (Normal) Message-ID: <1571111499121.20040716210158@gennick.com> To: Wolfgang Breitling Subject: One last question MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 5356 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jonathan@gennick.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Wolfgang, One last question, and then I'm done for the night. Here's that query again: SQL> SELECT * 2 FROM ( SELECT flag, TO_NUMBER(num) num 3 FROM subtest 4 WHERE flag IN ('A', 'C') ) 5 WHERE num > 0; ERROR: ORA-01722: invalid number How can I know whether it is "num > 0" that is causing the error? Could it be that TO_NUMBER(num) is being evaluated *before* the subquery's WHERE clause filters out rows NOT IN ('A', 'C')? In other words, how can I know that the problem I'm seeing is really the result of the two queries being merged? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://five.pairlist.net/mailman/listinfo/oracle-article, or send email to Oracle-article-request@gennick.com and include the word "subscribe" in either the subject or body. ---------------------------------------------------------------- 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 -----------------------------------------------------------------