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

Home -> Community -> Usenet -> c.d.o.server -> Re: Creating Contraint using sql

Re: Creating Contraint using sql

From: Gary England <gengland_at_hiwaay.net>
Date: 1997/09/18
Message-ID: <3421D188.7E36@hiwaay.net>#1/1 








Cuong Quyen Truong wrote:


> 

> Does anyone know how to make constraint between relations. For example

> Relation A has attributes a1(NUMBER) a2(NUMBER) and Relation B has

> attribures b1(NUMBER) b2(NUMBER) then I would like to make a contraint

> which say that if a1=b1 then a2 must be  > b2.




One way is with a database trigger that is fired on insert/update
commands to abort the action if the contraint is violated.
Received on Thu Sep 18 1997 - 00:00:00 CDT












Original text of this message













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