- Select File--> Table Editor.
The Table Editor dialog box opens.
- Select the server on which the table resides.
- Specify a table owner and table name.
Note:
You can use patterns to select table names from
a list of matching tables.
- Use the percent character (%) to match a string of any length
containing any characters. For example, to list all tables with
a name beginning with the letter A, enter A%.
- Use the underscore character (_) to match a single character.
For example, to list all tables with an owner that has the letter
A in the second position, enter _A%.
- Click List Tables.
The Tables dialog box opens.
- Select a table from the list.
The Table Editor dialog box opens.
- Select a Save Mode.
- Immediate
The table is updated at the database server immediately after
each change.
- End
The table is updated at the database server after you finish
entering all changes. Other users will not be able to make changes
to the table while you are making your changes.
- Click Edit.
The Edit Table dialog box opens.
- Type search conditions:
- For a simple search
Type search values in the Value column.
- For an advanced search
Type search criteria in the Additional search criteria field
to specify more complex search conditions.
Note:
You can enter any valid SQL predicate in this field.
- Click Start Search.
The first matching row is displayed in the Value column.