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

Home -> Community -> Usenet -> c.d.o.misc -> trigger help

trigger help

From: Kenny <karosenb_at_erols.com>
Date: Mon, 15 Nov 1999 10:30:23 -0500
Message-ID: <3830270E.D5671C08@erols.com> 





I have a table called 'SHOW' that will soon be changed to allow an end user
to associate a 'SHOW_ID' with a 'channel_ID' or an episode_ID (but not
both).  This means that show will contain nullable FKs to channel and
network.  Can I write a mutex trigger to require that one is set but not
both?



if so can somone provide an example?


thanks


-Kenny







Received on Mon Nov 15 1999 - 09:30:23 CST












Original text of this message













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