5.3.5 Using the Design Pane

Learn about how to use the Design pane.

Information on how to use how to use the Design pane includes the following topics:

• About Supported Column Types
  Columns of all types available in Oracle Database 10g Release (10.2) or later display as objects in the Design pane.
• Adding an Object to the Design Pane
  You add an object to the Design pane by selecting it from the Object Selection pane.
• Resizing the Design and Results Panes
  As you select objects, you can resize Design and Results panes by selecting the Bottom Splitter in the center of the page.
• Removing or Hiding Objects in the Design Pane
  You remove or hide objects in the Design pane by selecting controls at the top of the object.

5.3.5.1 About Supported Column Types

Columns of all types available in Oracle Database 10g Release (10.2) or later display as objects in the Design pane.

Note the following column restrictions:

• You may only select a maximum of 60 columns for each query.

• The following column types are not selectable and cannot be included in a generated query:

  • BLOB

  • NCLOB

  • RAW

  • LONG

  • LONG RAW

  • XMLType

  • Any other nonscalar column types

5.3.5.2 Adding an Object to the Design Pane

You add an object to the Design pane by selecting it from the Object Selection pane.

To add an object to the Design pane:

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

   Query Builder appears.

2. Select an object from the Object Selection pane.
   
   Description of the illustration query_builder_select.png

   The selected object appears in the Design Pane. The icon next to the column name represents the type of the column.

3. Select the columns to be included in your query by clicking the check box to the left of the column name.

   When you select a column you are indicating it is included in the query. As you select a column, it appears on the Conditions tab. Note that the Show check box on the Conditions tab controls whether a column is included in query results. By default, this check box is selected.

   To select the first twenty columns, click the Table Actions icon in the upper left corner of the object. The Actions window appears. Select Check All.

4. To execute the query and view results, click Run (Ctrl+Enter).

   The Results pane displays the query results.

See Also:

Specifying Query Conditions

5.3.5.3 Resizing the Design and Results Panes

As you select objects, you can resize Design and Results panes by selecting the Bottom Splitter in the center of the page.

The Bottom Splitter resembles a gray horizontal rule in the center of the page. Move the Bottom Splitter up and down to shrink and expand the Design pane.

5.3.5.4 Removing or Hiding Objects in the Design Pane

You remove or hide objects in the Design pane by selecting controls at the top of the object.

To remove an object, select the Remove (X) icon in the upper right corner. To temporarily hide the columns within an object, click the Show/Hide Columns (-) icon.