When Do You Use a Trigger To Populate Sequenced Prime Key?
From: Simeon Rice <tampa_at_bucs.com>
Date: Wed, 29 Jan 2003 18:59:06 GMT
Message-ID: <_vVZ9.492964$y74.3423905_at_news.easynews.com>
Date: Wed, 29 Jan 2003 18:59:06 GMT
Message-ID: <_vVZ9.492964$y74.3423905_at_news.easynews.com>
When would you use an insert trigger to populate the key rather than just a sequence.nextval on your insert statement?
I'm reviewing the triggers in a database that I'm currently working on (for a 3rd party app) and I noticed they used trigger method for certain tables.
Thanks. Received on Wed Jan 29 2003 - 19:59:06 CET