Every table from the Data Source Explorer view can be displayed and edited in the Table Explorer view by pressing the Edit button from the contextual menu or by double-clicking one of its fields. To modify a cell's content, double click it and start typing. When editing is finished, Oxygen XML Editor plugin will try to update the database with the new cell content.
The Table Explorer View
You can sort the content of a table by one of its columns by clicking on its column header.
Note the following:
For performance issues, you can set the maximum number of cells that will be displayed in the Table Explorer view ( the Limit the number of cells field from the Data Sources Preferences page). If a table having more cells than the value set in Oxygen XML Editor plugin 's options is displayed in the Table Explorer view, a warning dialog will inform you that the table is only partially shown.
You will be notified if the value you have entered in a cell is not valid (and thus it cannot be updated).
If the content of the edited cell does not belong to the data type of the column, an Information dialog will appear, notifying you that the value you have inserted cannot be converted to the SQL type of that field. For example, in the above figure propID contains LONG values. If a character or string was inserted, you would get the error message that a String value cannot be converted to the requested SQL type (NUMBER).
If the constraints of the database are not met (like primary key constraints for example), an Information dialog will appear, notifying you of the reason the database has not been updated. For example, if you'd try to set the primary key propID for the second record in the table to 10 also, you would get the following message:
Duplicate entry for primary key
The usual edit actions (Cut, Copy, Paste, Select All, Undo, Redo) are available in the popup menu of the edited cell.
The contextual menu available on every cell has the following actions:
Some of the above actions are also available on the Table Explorer toolbar: