When updating values of a column for a table in the data editor, if 2 identical rows exists, both get update when I am only intending on updating 1 row. It seems Ora Dev Studio is using values within a row to update instead of using the unique row id to update a table in the data tab of a table. Is this the intended functionality? Is there a setting that can change this?
Thanks
Ora Developer Studio Table Update
Thank you for your post.
in the WHERE section to update table records without unique key in Data Editor.
If a record is not unique, all records satisfying the condition will be changed.
Maybe this functionality will be implemented in the new version of the product.
Yes, OraDeveloper Studio uses a complete set of the selected columnsIt seems Ora Dev Studio is using values within a row to update
instead of using the unique row id to update a table in the data tab of a table.
Is this the intended functionality?
in the WHERE section to update table records without unique key in Data Editor.
If a record is not unique, all records satisfying the condition will be changed.
This situation cannot be changed.Is there a setting that can change this?
Maybe this functionality will be implemented in the new version of the product.