Hi,
Is it possible to load from a flat file into an oracle table using perl. The
data fields is in fixed form length and the load is a conditional load.

Here is the sample flat file 

MBOC      YR_1991   REGROLL    BSPSIEB                    1.000000
1.000000
ALLEP     YR_1991   REGROLL    COFYE                     24.000000
24.000000
ALLEP     YR_1991   REGROLL1   COLOP                     48.000000
48.000000
MBOC      YR_1991   REGROLL1   BSPSIEB                    1.000000
1.000000
ALLEP     YR_1991   REGROLL2   COFYE                     24.000000
24.000000
ALLEP     YR_1991   REGROLL2   COLOP                     48.000000
48.000000

The script should load only thows rows where the third column is "REGROLL"
or "REGROLL2" and discard the rows with third column as "REGROLL1".

How do I go about writing a perl DBI script to do this.

I am xtremely new to perl and in the process of reading the PERL DBI Book.

PLease Please Help.

Thanks
Anurag

Reply via email to