Viewing SQL Script Results

You use the Manage Script Results page to view and delete script results.

You can also select script results to view from the Icons view of the SQL Scripts page, and from the Results column of the SQL Scripts page Details view.

Topics:

Viewing Results from the SQL Scripts Page

To view script results from the SQL Scripts page:

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

    The SQL Scripts page appears.

  2. On the Tasks list, click Manage Results.

  3. For the results you want to view, click the View Results icon.

    The Manage Script Results page appears, listing available results for the script.

    Description of the illustration sql_m_results.gif follows
    Description of the illustration sql_m_results.gif

  4. Click the View Results icon for the results you want to view. The View icons display on the far right side of page under the heading View Results.

    The Results page appears. See "About the Results Page".

About the Results Page

The Results page displays the script name and status (Complete, Canceled, Executing or Submitted), and lists the statements executed.

Description of the illustration sql_s_result.gif follows
Description of the illustration sql_s_result.gif

On the Results page you can:

  • Choose the view. Click the Detail or Summary option and click Go to specify whether to display complete or summarized information.

  • Choose the number of rows to display. In Summary view, make a selection from the Display list and click Go to specify the number of rows displayed.

  • Sort the statement report. In Summary view, select a column heading to sort the listed values by that column.

  • Edit the script. Click Edit Script to load the script into the Script Editor. See "Using the Script Editor".