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

Home -> Community -> Usenet -> c.d.o.tools -> Re: constraints

Re: constraints

From: Kenneth Koenraadt <plovmand_at_hotmail.com>
Date: Sun, 05 Aug 2001 20:53:57 GMT
Message-ID: <3b6db0c8.3455287@news.mobilixnet.dk>

On Sat, 4 Aug 2001 17:39:11 +0300, "mgkiourt" <mgkiourt_at_otenet.gr> wrote:

>a) Airplanes have to be maintened at least once a year but at the
> latest every 50000 miles.
>b) Employees have to spend their yearly holidays until Jan of the
> following year.
>Any help?
>Thanks.Mike
>
>

Hi Mike,

Constraints are not appropriate for maintaining business logic as you describe it. Their purpose is to maintain data integrity and very simple business rules ( check constraints ).

You should move the business logic to the application layer instead.

Regards,
Kenneth Koenraadt
Systems Consultant
Oracle DBA
plovmand@<no-spam>hotmail.com Received on Sun Aug 05 2001 - 15:53:57 CDT

Original text of this message

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