pl/sql iterate through ext file dir of csv files & count unique records

From: cma <cnamraehs_at_yahoo.com>
Date: Mon, 18 Jun 2007 08:48:29 -0700
Message-ID: <1182181709.291891.152570@u2g2000hsc.googlegroups.com>

can pl/sql iterate through an external to oracle csv file directory with pipe(|) field delimiters and count unique records based on fields 1,2,3,7,& substring data in field 8?

record in file like...

B12345|ramirez|jorge|m|x234||01/09/2006|text text1 text|
B12345|ramirez|jorge|m|x231||01/09/2006|text text1 text|
B12345|ramirez|jorge|m|x232||01/07/2006|text text text|
B12345|ramirez|jorge|m|x233||01/09/2006|text text text|

only fields 1,2,3,7 would be unique identifier... plus substring text1 in field 10

print file name, unique record count, and datestamp of file :

filename1.csv..... 131,345 .....01/15/2006 filename2.csv...... 29,020 ......03/08/2007

ideally this would populate (insert) to a stat table

thanks you Received on Mon Jun 18 2007 - 10:48:29 CDT