Re: constraints
From: Kenneth Koenraadt <plovmand_at_hotmail.com>
Date: Sun, 05 Aug 2001 20:53:57 GMT
Message-ID: <3b6db0c8.3455287_at_news.mobilixnet.dk>
Date: Sun, 05 Aug 2001 20:53:57 GMT
Message-ID: <3b6db0c8.3455287_at_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_at_<no-spam>hotmail.com
Received on Sun Aug 05 2001 - 22:53:57 CEST