Here is an API generated query - Not sure what is wrong.
UPDATE T123
SET COL1 = 1, VER1 = VER1 + 1
INNER JOIN
SELECT C1
FROM (SELECT T.NUM_FLD C1 FROM WAPTDT_123 T) TAB ON C1 = REQUEST_ID
gives me error
SQL command not properly ended
All columns are present in table, I believe something is wrong with the join and running this command on oracle.
EDIT
One more thing is, the
SELECT C1
FROM (SELECT T.NUM_FLD C1 FROM WAPTDT_123 T) TAB
part of query is fixed as I am getting from some API.
See Question&Answers more detail:os