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