Edit/View Value (Data or Table Column) -- cannot Edit data, but can Update
Hello,
According to Oracle SQL Developer's Help Center, the "Edit/View Value (Data or Table Column)" dialog box should let us "change the data value" if we "are permitted to modify the data." We are trying to use such dialog box to edit/update data without having to write an Update statement, but it's not letting us. We do have permission to update the data, as we can update it via Update statements. Even as the owner of the schema.table, it won't let us change the value in the "Edit/View Value (Data or Table Column)" dialog box.
Any ideas?
We are on SQL Developer Version 3.0.0.4, Build MAIN-04.34, and Oracle Database 11gR1 (11.1.0.7).
Thank you,
Alex Larzabal.