Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> using insert trigger to update

using insert trigger to update

From: <bgastine_at_giveblood.org>
Date: 1997/05/01
Message-ID: <862512675.32745@dejanews.com>#1/1

Is there a way to use an INSERT trigger to accomplish a (conditional) UPDATE command? My situation is that SQL*Loader is being used to itteratively load data records into a table. If the record is new, then the INSERT should proceed as normal. If the record already exists, the update command should work.

Thanks,
Brian Gastineau
bgastine_at_giveblood.org

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Thu May 01 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US