Show TOC

Changing Data in the DatabaseLocate this document in the navigation structure

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.

Note

Procedure


    1. In the explorer tree, select the table in which you want to change data.

    2. 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)

    3. 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

    1. In the context menu of the table editor, choose New Row.

    2. Enter the values.

      To insert a LOB value, choose Start of the navigation path Import Cell From... Next navigation step File End of the navigation path in the context menu of the cell to which you want to import the changed value.

    3. 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:

    1. In the context menu of the LOB value, choose Start of the navigation path Export Cell To... Next navigation step File End of the navigation path.

    2. Change the LOB value using a suitable editor.

    3. Choose Start of the navigation path Import Cell From... Next navigation step File End of the navigation path 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