RE: Out of topic :Compare 2 data files in unix

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 <ORACLE-L_at_fatcity.com> 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_at_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_at_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_at_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_at_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).