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

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.