Re: Flat File Data Load

From: Bill Manry - Oracle Corporation <bmanry_at_upsizeme.us.oracle.com>
Date: 21 Oct 1994 19:10:12 GMT
Message-ID: <3893mk$t98_at_dcsun4.us.oracle.com>

Jodi Showers (jshowers_at_cmi.on.ca) wrote: [...]
>flat to single record relationships. It'll work for most circumstances, but
>if you need master detail or foreign key, or want to use a sequence you'll
>have to do a little pro*c.

Actually you can do master-detail loads with SQL*Loader in a single pass by using multiple "INTO TABLE <name>" clauses with suitable WHEN criteria. It ain't always pretty and some input layouts are too obtuse to handle. But it's worth considering unless you're the type who codes Pro*something or oci in their sleep.

/b

---

Bill Manry
Oracle Corp. / Mainframe & Integration Technologies / BManry_at_us.oracle.com #include <disclaimer.usual> Received on Fri Oct 21 1994 - 20:10:12 CET