1. Can the Toad Popup Editor be used to edit the XML without affecting the XML format?
2. Can the values in the result set or data grid be edited?
A data grid is fully editable via popup editor or via grid itself providing that the query returns a result set that can be updated no matter what the data type is e.g. XML, CHAR, etc. Query statement must return the ROWID to be editable. You should also have the necessary privilege to update the data. For example:
select * from employee - this is not editable.
select employee.*, rowid from employee - this is editable.
You can also execute "edit employees where <expression>" to edit the record/row. Commit is required for the changes to take effect. Table format and column format stays the same.
