|
-
You don't need PL/SQL, it can be done in SQL, but only if the subquery returns just one row.
If
(SELECT WON + LOST
FROM MATCHES
WHERE PLAYERNO = PLAYERS.PLAYERNO)
returns two rows, Oracle doesn't know which of the two rows has the new value of NUMBER_OF_SETS. Then you get the 'single row query returns more than one row' error.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|