Viewing and editing data with the table data editor
You can use the table data editor to view and edit the
data in several different types of objects, such as tables, views,
and aliases.
Table data editor overview
You can use the table data editor to retrieve and display
the data from the database. The table data editor can be opened in
read-only mode or in edit mode.
Viewing data in the table data editor in read-only mode
Open the table data editor in read-only mode to view the
contents of a table, view, alias, materialized query table, nickname,
or synonym. When you view the data in read-only mode, you cannot edit
the data.
Editing data with the table data editor
Open the table data editor in edit mode to edit the data
and save the changes to the database for a table, view, alias, or
materialized query table.
Refreshing the data in the table data editor
You can refresh the data that is displayed in the table
data editor. Data might be changed in the database after you have
opened the table data editor. The functionality to refresh the data
in the editor helps you to always work with a current copy of the
data.