Large data editor in sql window can clear write protected data

Claus Pedersen

Member³
I have a select in an SQL window, e.g.
SELECT * from hr.departments;
and view data in column department_name using large data editor.

When you click on the Edit data icon, you get the error "These query results are not updateable. Include the ROWID to get updateable results." and this is OK.
But now the data is editable and the previously disabled buttons (Open, Cut, Paste, Clear) are now enabled so the data can be further modified.

The data can not be saved in the database, but is still modified in the grid, so e.g. exporting results can give erroneous results.

Please correct this.
 
Back
Top