Re: Complex SQL

Art Scott wrote:

> Team[TeamID(pk), coach, rating]
> Player[PlayerID(pk), TeamID(fk)]
>
> Want to prevent data entry from having more than 12 players for each team.
> How can I do this in oracle9i?
>
> Thanks in advance.

Write a trigger that performs a RAISE_APPLICATION_ERROR when that condition exists. Received on Mon Apr 01 2002 - 05:25:09 CST