Re: Business Rules and Database Triggers
From: AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu>
Date: 1997/10/28
Message-ID: <34560397.33FA_at_charlie.cns.iit.edu>#1/1
Date: 1997/10/28
Message-ID: <34560397.33FA_at_charlie.cns.iit.edu>#1/1
THis business rule you can implement at table level using CHECK constraint
Ex:
CREATE TABLE X
(AGE NUMBER CONSTRAINT AGE_CHK CHECK ( AGE BETWEEN 18 AND 50)
-- ****************************************************************************** AMARENDRA B NETTEM 5039 N E River Road, Apt. 1A Certified Oracle DBA NORRIDGE, IL 60656 Whittman-Hart Inc., 311 South Wacker Drive, Suite 3500 Chicago, IL 60606. Ph.No. (708) 583 9870 (H) (312) 913 6758 (W) E-mail:nettama_at_charlie.cns.iit.edu, anettem_at_whittman-hart.com Homepage: http://www.iit.edu/~nettama **************************************************************************** Opinions are mine and do not necessarily reflect those of Whittman-hart Inc.Received on Tue Oct 28 1997 - 00:00:00 CET