Use the Table Data editor to modify data in tables accessed in procedural objects as you debug them. You can insert, update, or delete rows, and edit content of individual cells. Your table changes appear in the local view only, until you explicitly save or commit them to the database.
Once you open Table Data editor, you can use it from either Database Development or Database Debug.
To edit table data in Table Data editor:
Open the Table Data editor from the Referenced Tables view in Database Debug by any of these methods:
Double-click the table name in the table list
Right-click the table name and select Edit Table Data from the context menu
Click the Edit Table Data Button (
) in the Referenced Tables toolbarSelect Edit Table Data from the Referenced Tables dropdown menu
The table opens for editing in a new tab in Database Debug. If Database Development perspective is open, the table opens there as well. You can edit the table in either perspective, and changes appear in both perspectives.
To move within the table, use the scroll bar and mouse or:
Filter table data by entering a Where clause in the Retrieve frame below the table
To change data in a cell, navigate to the cell and do one of:
Click in the cell and type the data.
Right-click in the cell, choose Update Value to enter edit mode, and type or paste the data.
Click to select only the data in the cell, and cut, copy, or paste cell contents using the cell's context menu or the keyboard.
To edit image data, edit the hexadecimal code that appears in the cell, for example, 0x031328.
To set a cell's value to Null, right-click in the cell and choose Set Null.
If Set Null is grayed out, this cell cannot be null.
To insert a row:
Right-click anywhere in the table to open the context menu, and select Insert Row.
A new row opens in the view after the last row in the table.
Enter data in each cell, using Tab to move to the next cell.
To delete a row, click in the row, right-click to open the context menu, and select Delete Row.
The row is removed from the view.
To cut, copy, or paste a row, right-click to open the context menu, and select Cut Row, Copy Row, or Paste Row.
(Optional) To change Table Data editor preferences, choose Preferences from the context menu and set options in the Table Data editor preferences page.
Filtering and Sorting Table Data
Saving or Reverting Table Data Editor Changes
Refreshing Table Data from the Database
Viewing Referenced Tables While Debugging