Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: constraints
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