computing the difference between two big text files?

From: <bing-du_at_tamu.edu>
Date: Thu, 09 Dec 1999 22:37:42 GMT
Message-ID: <82pavl$nsn$1@nnrp1.deja.com>

Greetings all...

We have Oracle7 Server Release 7.3.4.0.1.

For some reason, we have to have people data (about 50,000 records) saved in a text file. Because people come and go frequently, this text file is updated periodically, e.g. monthly.

We need to keep track changes between the old text file and the new text file. We wrote some Perl code on unix and computed the difference between two text files. I have to say this method led to low efficiency and a pain in the neck.

Because we are able to load people data from text file to an Oracle table, I'm wondering if it's possible to first load the old and the new text data file into two separate tables respectively; then compute the difference between two tables?

I'm not that familiar with Oracle. Can anybody advice me if my idea feasible? How to actually implement this, via SQL*PLUS script?

Need your help badly,

Thanks,

Bing

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 09 1999 - 16:37:42 CST