Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g5K0dox28675 for ; Wed, 19 Jun 2002 20:39:50 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id JAA74439; Wed, 19 Jun 2002 09:39:06 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b71/bab) via UUCP id 00481760; Wed, 19 Jun 2002 09:03:28 -0800 Message-ID: Date: Wed, 19 Jun 2002 09:03:28 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Curiel, David" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Curiel, David" Subject: RE: Out of topic :Compare 2 data files in unix Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit man comm NAME comm - select or reject lines common to two files SYNOPSIS comm [ -123 ] file1 file2 DESCRIPTION The comm utility will read file1 and file2, which should be ordered in the current collating sequence, and produce three text columns as output: lines only in file1; lines only in file2; and lines in both files. If the input files were ordered according to the collating sequence of the current locale, the lines written will be in the collating sequence of the original lines. If not, the results are unspecified. OPTIONS The following options are supported: -1 Suppress the output column of lines unique to file1. -2 Suppress the output column of lines unique to file2. -3 Suppress the output column of lines duplicated in file1 and file2. .... David Curiel Bioinformatics Software Engineer Pioneer Hi-Bred -----Original Message----- Sent: Wednesday, June 19, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Load them into 2 oracle tables and do sql queries. Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L Sent: Wednesday, June 19, 2002 9:13 AM > Hi, > I have 2 data files file1 & file2. > I want to get all those records which are present only in file2 & not in > file1. > Also want records which are present in both ,separately. > I tried to use diff , but not entirely familiar with the diff options. > > Thanks > Manoj. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: adar76@inter.net.il Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Curiel, David INET: david.curiel@pioneer.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).