Help using SQL Loader to count the number of fields being loaded

serenityslr · #1 (**permalink**) 12-31-12, 14:12

I am loading data into tables using SQL Loader. My datavaires from being comma delimited to simply using whitespace.

The problem is that vendors will often decide to add or remove a column without notification. Is there a way to have the loader check the number of fields then either break if it's incorrect or load the data if it is correct?

Any help you can provide will be greatly appreciated

anacedent · #2 (**permalink**) 12-31-12, 15:02

what exactly does the "checking"?
based upon what criteria does the checker decide if file is correct or not?

You have a business process problem that is independent of & external to Oracle.

LKBrwn_DBA · #3 (**permalink**) 01-02-13, 10:02

If the files are in *nix OS, you could use "awk", something like this:

Code:

awk -F' ' 'BEGIN {minf=9999; maxf=-1}
{ if(NF < minf) minf = NF;
  if(NF >= maxf) maxf = NF;
} END {print "Min fields = "minf", Max fields = "maxf;}
' TheFile.txt

Internet Services

Web Development

Digital Marketing

Consumer Tech