Selecting Objects

About Supported Column Types

Columns of all types available in Oracle Database 10g Release (10.2) 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 selectable and will not be included in a generated query:

  • BLOB

  • CLOB

  • NCLOB

  • RAW

  • LONG

  • LONGRAW

  • XML TYPE

  • Any other nonscalar column types

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. Navigate to Query Builder:

   1. Click the SQL Workshop icon on the Workspace home page.

   2. Click Query Builder.

      Query Builder appears.

2. Select an object from the Object Selection pane.

   The selected object appears in the Design Pane. Note that a graphical representation of the datatype displays to the right of the column name.

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 will be used 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. Be default, this check box is selected.

   To select the first twenty columns, click the small icon in the upper left corner of the object and then select Check All.

4. To execute the query and view results, click Run.

   
   

   Tip: You can also execute a query by pressing CTRL + ENTER.

   
   

   The Results pane displays the query results.

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 icon in the upper right corner. To temporarily hide the columns within an object, click the Show/Hide Columns icon.