Re: Importing from a flat file
From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Wed, 27 Aug 2003 17:42:49 -0700
Message-ID: <3F4D5009.5A5E9864_at_exxesolutions.com>
Date: Wed, 27 Aug 2003 17:42:49 -0700
Message-ID: <3F4D5009.5A5E9864_at_exxesolutions.com>
Bill Prew wrote:
> 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.
Does your Oracle have a version number?
If prior to 9i UTL_FILE. If 9i UTL_FILE or external tables.
Go to http://tahiti.oracle.com to look up syntax and find examples.
-- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Thu Aug 28 2003 - 02:42:49 CEST