Editing Database Records

This topic describes the procedure for editing database records to modify their details in the data editor.

Follow these steps to modify a database record:

1. Double-click the table cell in the Data Viewer window.
   The DB Navigator - View Record dialog box opens displaying the qualified name of the database object (table/view/materialized view) you selected.

   
   
   

2. The following information is displayed in the dialog box:
   • Column Names
   • Record value for those columns
   • Character Types of the columns
   • Maximum character length of each column within parenthesis
3. Edit the record values in the text box. For columns that have text box editing enabled, you can also open the text box editor and edit the record content there.
4. Use the search box to search for a specific record in the table and edit its values.
5. Navigate to the previous or next record, or to the first or last record of the table using the respective icons. You can also sort the table columns alphabetically.

   Note:

   If Auto-Commit is enabled for the database connection in which you are making the edits, your changes get saved to the database immediately.