Re: SQL*Loader question
From: jhouchen <jhouchen_at_epix.net>
Date: 1996/04/30
Message-ID: <3186EDE5.448_at_epix.net>#1/1
Date: 1996/04/30
Message-ID: <3186EDE5.448_at_epix.net>#1/1
Another alternative, maybe.
Create a temp table that matches your target table, as Chuck suggests. Have SQL*Loader replace all data on upload. Create a database trigger on the temp table that calls a PL/SQL procedure that either updates or inserts your source.
jim Received on Tue Apr 30 1996 - 00:00:00 CEST