From oracle-l-bounce@freelists.org Tue Oct 26 06:48:57 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i9QBmvh02835 for ; Tue, 26 Oct 2004 06:48:57 -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 i9QBmvI02828 for ; Tue, 26 Oct 2004 06:48:57 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BF23572C4AE; Tue, 26 Oct 2004 06:54:55 -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 22636-28; Tue, 26 Oct 2004 06:54:55 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 066A072C198; Tue, 26 Oct 2004 06:54:55 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: RE: Something I'm missing in minus set operation... Date: Tue, 26 Oct 2004 12:54:11 +0100 Message-ID: <83FC2D1BC95D884894735B11B562A41C08377A3E@i2km06-ukbr.domain1.systemhost.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Something I'm missing in minus set operation... Thread-Index: AcS7UWaY/iw+sojXQ2GVC3yAiMC7DwAAGGAg From: To: Cc: X-OriginalArrivalTime: 26 Oct 2004 11:54:12.0628 (UTC) FILETIME=[829D5D40:01C4BB52] X-archive-position: 11523 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: arul.kumar@bt.com Precedence: normal Reply-To: arul.kumar@bt.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org may be the data in your table is not in UPPER CASE! Also, I think u may have to join both the tables on owner name and table = name to get the actual differences!! -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Stephens, Chris Sent: 26 October 2004 12:46 To: oracle-l@freelists.org Subject: Something I'm missing in minus set operation... We have a table here used by a web app to determine columns for particular tables. The table is out of sync with the actual columns in the tables. To determine which columns should be removed from the table I wrote the following: Select distinct(trim(col_name)) >From owner.col_dim Minus Select distinct(trim(column_name)) >From sys.all_tab_columns; ...but that is yielding the wrong results. What am I missing? The datatypes are the same. ...i don't even think I should need the trim in there but that too yields wrong results. ? ....it is very early here so I have somewhat of an excuse. Thanks chris=3D20 -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l