ORA-00933: SQL command not closed properly

[rhicky]

Friends,
I need to update below. However, when running Oracle presents the message below. How to solve the problem?

ORA-00933: SQL command does not suit properly
SQL parse error location [

Select all

UPDATE pfunc 
SET DTAVISOPREVIO = (DTAVISOPREVIO+NRODIASAVISO) 
FROM PFUNC y 
WHERE y.NRODIASAVISO > 0 
AND y.TEMAVISOPREVIO = 1 
AND y.CHAPA IN ('0103027', '0103212')

[dr_gori]

There are over there.

Select all

UPDATE pfunc  
SET DTAVISOPREVIO = (DTAVISOPREVIO+NRODIASAVISO) 
--------------FROM PFUNC y 
WHERE NRODIASAVISO > 0 
AND TEMAVISOPREVIO = 1 
AND CHAPA IN ('0103027', '0103212')