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

cma wrote:
> 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

Yes. But set it up an an external table and just use SELECT COUNT(*).
Never us PL/SQL to do what SQL can do.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org