Help! Sybase SQL to Oracle...

Here is the Sybase SQL:

 UPDATE TOTAL_COMP_DATABASE t SET UP_DUP = 'Y' WHERE (SELECT COUNT(*) FROM

      PS_UPLOAD1 U WHERE U.EMPLID = T.EMPLID) > 1 As far as I know, that is illegal in Oracle, is there a way to get around it? If I try to use the above statement in Oracle, this is the returned error:

ORACLE OPARSE error -936 in cursor 23:

   ORA-00936: missing expression
Error at: SELECT

Thanks a lot for your help.

        -kibwe_at_wpi.wpi.edu Received on Tue Jan 16 1996 - 00:00:00 CET