Re: database constraints
From: Steve Gerard <sjg_at_qdot.qld.gov.au>
Date: 27 Jun 1994 01:20:51 GMT
Message-ID: <2ul9hj$dr_at_camelot.qdot.qld.gov.au>
Date: 27 Jun 1994 01:20:51 GMT
Message-ID: <2ul9hj$dr_at_camelot.qdot.qld.gov.au>
Ken Levine (kenl_at_icebox.iceonline.com) wrote:
: Triggers can do this right now and it doesn't take much more work. Just
: define a before insert or update of dept_code on row trigger that
: does this validation. As long as the trigger is enabled on the table the
: condition must hold.
Triggers are stored in a non compiled form and so are slower than the
performance I would expect if Oracle integrity constraints were
extended to support checks against the result of a query...
Received on Mon Jun 27 1994 - 03:20:51 CEST