That worked fine.

Initially I was wondering if this could be done without PL/SQL, but the sample code worked fine

I have a book called 'The SQl Guide to ORACLe' by Van Der Lans and it has the follwing sample code which leads me to believe you can do an update of this type in SQLPLUS:

UPDATE PLAYERS
SET NUMBER_OF_SETS =
(SELECT WON + LOST
FROM MATCHES
WHERE PLAYERNO = PLAYERS.PLAYERNO)
WHERE PLAYERNO IN
(SELECT PLAYERNO
FROM MATCHES)


I attempted a similar update, but received an error. This book is about 9 years old so I was wondering if this was possible in older versions of ORACLE but not in V7 or above.

Thanks