When working in XML pop up editor grid, the formatter button (yellow double arrow button) is grayed out and the code cannot be formatted.
I run SELECT COL1, xmltype(xml) xmlcol, FROM sometbl WHERE rownum < 3 and double click on the record in the data grid.
To edit table's date you have to include the rowid in the select statement or run with the Toad EDIT command.
Example:
a. SELECT a.*, a.rowid FROM sometbl a;
b. EDIT sometbl
Records in the datagrid are now editable. In the popup editor the formatter button should be enabled.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center