Help with data conversion???

What method is best to convert a 190Mb file containing 1100 byte ASCII blocks (separated by hex 0A0D - LFCR), and store it into an Oracle7 data base??? The file is created elsewhere and they will not change it.

In addition, if-then-else decisions need to be made on each record. For example, convert a string YYJJJ julian date to Oracle date field. Some records maybe discarded entirely based on certain decisions.

Also, I only have Oracle and Unix at my disposal. Please send me email with any helpful suggestions regarding manipulation of Unix files with Oracle tools.

Thanks! Received on Wed Aug 30 1995 - 00:00:00 CEST