5.3.4 Using the Object Selection Pane

Use the Object Selection pane to search for and view tables, views, and materialized views within the current schema as well as select objects.

• Searching and Filtering Objects
  Use the Object Selection pane to search for and view tables, views, and materialized views within the current schema.
• Hiding and Restoring the Object Selection Pane
  You can hide the Object Selection pane by selecting the Collapse control.
• Selecting Objects
  Use the Object Selection pane to select objects.

5.3.4.1 Searching and Filtering Objects

Use the Object Selection pane to search for and view tables, views, and materialized views within the current schema.

To search or filter objects:

1. On the Workspace home page, click SQL Workshop and then Query Builder.

   Query Builder appears.

2. In the search field at the top of the Object Selection pane, enter a case insensitive query.
3. To view all tables or views within the currently selected schema, leave the search field blank.

5.3.4.2 Hiding and Restoring the Object Selection Pane

You can hide the Object Selection pane by selecting the Collapse control.

The Collapse control displays on the right side of the Object Selection pane. If the Object Selection pane displays, selecting this control hides it. Similarly, if the Object Selection pane is hidden, selecting this control causes the pane restores it. Select the Left Splitter (click above or below the Collapse control to manually resize the Object Selection pane.

5.3.4.3 Selecting Objects

Use the Object Selection pane to select objects.

The Design pane displays to the right of the Object Selection pane. When you select an object from the Object Selection pane, it appears in the Design pane. You use the Object Selection pane to select objects (that is, tables, views, and materialized views) and the Design pane to identify how those selected objects are used in a query.