Oracle triggers

From: <jdefreitas_at_my-deja.com>
Date: Wed, 10 Nov 1999 19:51:26 GMT
Message-ID: <80cibs$bsp$1@nnrp1.deja.com>

Hi. I am running Oracle 8.0.5, and have a question about triggers.

On our tables there are "dtInsertDate" and
"vchInsertBy" fields. I want to alter the
"TI" triggers (the triggers that execute when a
record is inserted) so that if a user does not supply the dtInsertDate, the field will be set to sysdate.

I was wondering if anyone had some PL/SQL examples of this, and also whether the trigger should fire before or after the insert (I assume after).

Thanks! - John G. de Freitas

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 10 1999 - 13:51:26 CST