On 06/13/07 15:02, Kevin Hunter wrote:
[snip]
>
> 'To enforce this rule without integrity constraints, you can use a
> trigger to query the department table and test that each new employee's
> department is valid. But this method is less reliable than the integrity
> constraint. SELECT in Oracle Database uses "consistent read", so the
> query might miss uncommitted changes from other transactions.'
Isn't it *supposed* to mis UNcommitted changes from other transactions?
--
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!