[Solved] ORA-00936: missing expression(UPDATED) [closed]

by


That syntax doesn’t looks correct. Try changing your query to something like below

UPDATE  
(SELECT ANAM.NAME,
ANAM.SEAT as NEWSEAT,
ANAM2.TRAIN_NAME,
ANAM2.SEAT,  
ANAM2.SEAT - ANAM.SEAT  AS TOTAL 
FROM TBL_PASSENGER ANAM
INNER JOIN TBL_TRAIN_LIST ANAM2 
ON ANAM.NO = ANAM2.ID ) t
SET t.NEWSEAT = t.TOTAL;

3

solved ORA-00936: missing expression(UPDATED) [closed]