SQL*Loader and Sequence Generated IDS...

From: Doug Moloney <Doug.Moloney_at_ae.ge.com>
Date: 1996/10/30
Message-ID: <3277CAC5.133F_at_ae.ge.com>#1/1


I have a case where there is a sequence generated primary key in a table that will be loaded using SQL*Loader. Will SQL*Loader allow the key to be generated in a before-insert trigger?

The second case is that a related table needs to store the sequence generated key by looking it up by the alternate key. Will SQL*loader allow the lookup and storage of the key in the related table?

Thanks
Doug.Moloney_at_ae.ge.com Received on Wed Oct 30 1996 - 00:00:00 CET

Original text of this message