Importing from a flat file
From: Bill Prew <billprew_at_cox.net>
Date: 27 Aug 2003 14:02:19 -0700
Message-ID: <477625b6.0308271302.4a0d3e09_at_posting.google.com>
[Quoted] I need some help getting started on some PL/SQL that will read records from a flat text file (fixed length format), and "merge" these into an existing database table. By "merge" I mean check if the row already exists with the same key, and only add records from the file that are new, skip over any that already exist. Received on Wed Aug 27 2003 - 23:02:19 CEST
Date: 27 Aug 2003 14:02:19 -0700
Message-ID: <477625b6.0308271302.4a0d3e09_at_posting.google.com>
[Quoted] I need some help getting started on some PL/SQL that will read records from a flat text file (fixed length format), and "merge" these into an existing database table. By "merge" I mean check if the row already exists with the same key, and only add records from the file that are new, skip over any that already exist. Received on Wed Aug 27 2003 - 23:02:19 CEST