Browse Data
You can browse or edit data according to your purpose. You can select Edit as default, Browse as default, or Browse Only when you begin a new Edit Definition.
- If you select Edit as default or Browse as default, you can switch between the edit and browse modes using the edit window Options menu.
- If you select Browse Only, you cannot switch to edit mode. In the Browse Only mode, you can open more than one instance of the same table.
Edit provides several ways to organize and manipulate data in the Table Editor to allow you to browse data efficiently. For example, you can specify selection criteria to limit the size of the fetch set and display a more manageable set of data. When a table contains a large number of rows, it can be very useful to selectively exclude rows from the display.
This section describes how to use the following tools:
- Join tables
- Join tables in the Table Editor to display related data from one or more additional tables.
- Indent
- Display the names of all tables joined in the Table Editor in an indented format to clarify relationships between tables.
- Unjoin tables
- Remove tables from the Table Editor.
- Find
- Search for specific data in a table.
- Exclude
- Remove rows from the display.
- Include
- Display only rows that satisfy a specified criteria.
- Show next
- Display the first excluded row between the row you selected and the next displayed row.
- Show all
- Display all excluded rows between the row you selected and the next displayed row.
- Sort
- Rearrange rows displayed in the Table Editor in ascending or descending order based on a specific column.
- Rearrange column order
- Position the columns to display the desired data more efficiently.
- Hide
- Remove a column from the display.
- Lock
- Reposition a column to the left (columnar display) or to the top (side label display) of the other columns. The column stays in that position when you scroll the data.