Re: Help with data conversion???
Date: 1995/09/02
Message-ID: <020995.16030756805.n_at_frontier.canrem.com>#1/1
>GIL QUIHUIZ (pdsc_at_netcom.com) wrote:
>: 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.
>Perl. It will do it all quite easily. Not to mention its a snap to write.
> The O'riely book 'Programming Perl' is the bible on the subject.
>
>d
>--
>Darrell Cavens
>dcavens_at_ingenia.com
>Ingenia Communications Corporation
Personally I would use PRO*C to convert the file so that SQL*LOADER can shove it in. Sounds like u have to do a lot of translation. But that just one mans opinion... Received on Sat Sep 02 1995 - 00:00:00 CEST