database

=======

UPDATE BOOKING JOIN res

ON BOOKING.CAR_REGESTRATION_NUM = res.CAR_REGESTRATION_NUM

SET BOOKING.amount = res.amount;

=====

i want to add amount to all column in booking but the system does not accepted

Error at: 1ine 1/16: ORA-e9971: missing SET keyword ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", 1ine 828 ORA-06512: at: "SYS.DBMS_SYS_SQL", 1ine 1658 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 813 ORA-06512: at "APEX_220200.WWN_FLOW_DYNAMIC_EXEC", 1ine 2046 1. UPDATE BOOKING JOIN RES 2. ON BOOKING,CAR_REGESTRATION_NUM = RES.CAR_REGESTRATION_NUM 3. SET BOOKING , amount = res. amount