home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,791 of 2,288   
   Holger Baer to Noons   
   Re: Implementing complicated constraints   
   01 Oct 04 09:14:09   
   
   XPost: comp.databases.oracle.server   
   From: holger.baer@science-computing.de   
      
   Noons wrote:   
   [...]   
      
   >   
   > Too much trouble.  The instead of trigger with a view is perfect   
   > for this.   
   >   
   > I like Tom Kite's idea of a FBI, as proposed by HB.  But I'm not   
   > sure it won't introduce other problems.  IIRC, Tom introduced   
   > that technique at a time when instead of triggers were not yet   
   > available.  He probably would have used the triggers nowadays.   
      
   I'm not sure if the FBI solution introduces other problems, but   
   that's a different question.   
      
   However I'm sure instead of trigger where available in 8.0, whereas   
   FBI was introduced in 8i. So I'm not sure about the conclusion that   
   Tom wouldn't use this nowadays. What do we say in cases like this?   
   It depends....   
      
   Cheers, Holger   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca