Prerequisites
You are logged on to the database as a database user.
Context
Changing data in the database means that you add a data record to a table, update a data record, or delete a data record. You can use the table editor for this.
Procedure
-
-
In the explorer tree, select the table in which you want to change data.
-
In the context menu of the table, choose
Content.
The data records are displayed.
To display only data records that fulfill specific criteria, in the context menu, choose
Filter. You can enter your filter criterion in the first row of a column.
More information:
SQL Reference Manual,
Predicate (predicate)
-
To switch to edit mode, select
Edit in the context menu of the table editor.
- Inserting Data Records
Prerequisites
You have the INSERT privilege for the table.
More information:
SQL Reference Manual,
Privilege Specification (priv_spec)
Procedure
-
In the context menu of the table editor, choose
New Row.
-
Enter the values.
To insert a LOB value, choose
in the context menu of the cell to which you want to import the changed value.
-
In the context menu of the new data record, choose
Insert Row.
- Updating Data Records
Prerequisites
You have the UPDATE privilege for each table column.
Procedure
To update (change) a data record, overwrite the old values.
Note
The system applies all changes immediately.
To change a LOB value, proceed as follows:
-
In the context menu of the LOB value, choose
.
-
Change the LOB value using a suitable editor.
-
Choose
in the context menu of the cell to which you want to import the changed value.
- Deleting Data Records
Prerequisites
You have the DELETE privilege for the table.
Procedure
In the context menu of the data record, choose
Delete Selected Row.
Note
The system immediately deletes the data record from the database.
- Exiting Edit Mode
In the context menu of the table editor, deselect
Edit.
Next Steps
Table Editor
SQL Reference Manual,
Data Manipulation