Oracle when editing data: These query results are not updatable, please use ROWI or select ... For update to get updatable results

When we operate on an Oracle database, we sometimes want to manipulate some of the data after we have finished querying the results, and when we click Edit (a lock flag), we are prompted with the error in the above question: These query results are not updatable, please use ROWI or select ... For update to get updatable results. We can use two solutions according to the error message:

Workaround 1: write the for update after the query statement , such as: SELECT * from table name for update;

Workaround 2: Use the rowid property in the column of the query, such as: Select rowID, table name. * from table name;

In addition, we can also be resolved by selecting the table to edit on the left, right-editing the data, and editing the data directly, you will see the same code as Solution 2 in SQL.

Oracle When editing data: These query results are not updatable, please use ROWI or select ... For update to get updatable results