PL/SQL: Update row based on ROWID

Question

I am trying to update a row in a table which has no unique index. So, I selected the ROWID of the row I want to update and now I want to update the row like this:

UPDATE MYTABLE SET MYCOLUMN = 0 WHERE ROWID = "AAAIWWAAFAAApwDADR"

MYCOLUMN is of type NUMBER(1)

I get the error: invalid identifier [SQL State=42000, DB Errorcode=904]

Any idea why?

Answer 1

Try using single quotes:

UPDATE MYTABLE SET MYCOLUMN = 0 WHERE ROWID = 'AAAIWWAAFAAApwDADR'

Answer 2

The easier way is write at the end of your select the cmd for update it allow you to update the row that you desire. Obs: I'm used to do that on Oracle PL/SQL Developer.